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,

---

can we use cartesian join in informatica

3 Answers   IBM,

---

tell me 7.x and 8.x diferrencess(but not transformations)

1 Answers  

---

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

1 Answers   Accenture, Unisoft Infotech,

---

What are partitions in informatica and which one is used for better performance?

2 Answers  

---

---

two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .

2 Answers   TCS,

---

tell me the push down optimization

2 Answers   Wipro,

---

what is incremental loading ?

12 Answers   CTS, IBM, Oracle, TCS,

---

Sequence generator, when you move from develoment to production how will you reset

0 Answers  

---

What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,

---

What are the static cache and dynamic cache in informatica?

0 Answers  

---

Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks

4 Answers   IBM,

---