Answer / guest

we can not have flat override in any of the Transormation.
We have only sql query here we can use the custom query for
relational sources and we have lookup override is there
here we can sql query for relational sources suppose we
going to lookup on relational table.

where actually the usage of push down optimization happens...

2 Answers  

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers  

---

What is the use of source qualifier?

0 Answers  

---

What are the uses of a Parameter file?

3 Answers   CSC,

---

What are the types of metadata that stores in repository?

2 Answers  

---

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

---

follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000

5 Answers   IBM,

---

What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,

---

Where should yoU place the flat file to import the flat file defintion to the designer?

4 Answers  

---

What are the popular informatica products?

0 Answers  

---

Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

2 Answers   CTS,

---