Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

0 Answers  

---

What is union transformation in informatica?

0 Answers  

---

What differs when we choose the sorted input for aggregator transformation?

0 Answers  

---

why union transformation is active transformation?

6 Answers   IndiGo, TCS,

---

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

4 Answers   Cap Gemini, IBM,

---

What are the circumstances that infromatica server results an unreciverable session?

1 Answers  

---

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,

---

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,

---

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

---

why sequence generator should not directly connected to joiner transformation ?

1 Answers   ANZ,

---

Differentiate between joiner and lookup transformation?

0 Answers  

---