I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

2 Answers   DELL, iGate,

---

What is IQD file?

1 Answers  

---

From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,

---

What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers  

---

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,

---

Difference between session variables and workflow variables?

2 Answers   Informatica,

---

Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,

---

What is the need of etl tools?

0 Answers  

---

Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation

1 Answers   Puma,

---

Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!

2 Answers  

---

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,

---

Can i create a lookup table without cache.

7 Answers   iGate,

---