Answer / pawan

With the batch file , we can run sessions either in sequential or in concurrently.

Grouping of Sessions is known as Batch.

Two types of batches :
1)Sequential: Runs Sessions one after another.
2)Concurrent: Run the Sessions at the same time.


If u have sessions with source-target dependencies u have to go for sequential batch to start the sessions one after another. If u have several independent sessions u can use concurrent batches Which run all the sessions at the same time.

Answer / sarthak

u wrote about batches....not about Batch file... its a
different things..

BATCH FILE
A file that contains a sequence, or batch, of commands.
Batch files are useful for storing sets of commands that are
always executed together because you can simply enter the
name of the batch file instead of entering each command
individually.

what is shortcut in informatica? difference between shortcut,reusable object?

2 Answers   Virtusa,

---

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

explain different types of modeling.

2 Answers  

---

Slowly changing dimensions, types and where will you use them

0 Answers  

---

Explain about the concept of mapping parameters and variables ?

3 Answers   HCL, TCS,

---

Which files are created during the session rums by informatics server?

0 Answers  

---

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,

---

Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.

5 Answers   DELL, TCS,

---

Explain the different dimensions.

0 Answers  

---

Explain about cumulative Sum or moving sum?

0 Answers   Informatica,

---

what is casual dimension?

6 Answers   IBM,

---

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

---