One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,

---

What is a surrogate key?

0 Answers  

---

Explain lookup transformation in informatica

0 Answers   Informatica,

---

how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z

3 Answers   CTS,

---

why we r using presql&postsql in source qualifier?

1 Answers   HP,

---

what is normalizer transformation?

4 Answers   Wipro,

---

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

0 Answers   HCL,

---

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,

---

can we see default group,when we use router?if yes how?

2 Answers   L&T,

---

What is the difference b/w natural key and surrogate key

1 Answers  

---

explain different types of modeling.

2 Answers  

---