Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

2 Answers   CTS,

---

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

2 Answers   Mphasis,

---

How would you copy the content of one repository to another repository?

0 Answers  

---

If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,

---

What is the Router transformation?

2 Answers   Informatica,

---

On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

6 Answers  

---

Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers  

---

how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)

6 Answers   Accenture,

---

I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

4 Answers   Patni,

---

can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,

---

Which transformation should we use to normalise the COBOL and relational sources?

0 Answers   Informatica,

---

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.

8 Answers  

---