If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 Answers  

---

Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 Answers  

---

What are pre and post-session shell commands?

0 Answers  

---

What is aggregate cache in aggregator transformation?

0 Answers   Informatica,

---

What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,

---

---

In which circumstances that informatica server creates Reject files?

2 Answers  

---

What are the session parameters?

3 Answers  

---

Which kind of index is preferred in DWH?

3 Answers  

---

What is an active transformation?

0 Answers   Informatica,

---

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers  

---

If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?

1 Answers   Hexaware,

---

How many ways you create ports?

1 Answers  

---