When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
IBM,
3 16272Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
IBM,
11 15806hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.
TCS,
5 6487Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
2275What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
3 6756Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
5 9746I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?
TCS,
6 8860I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?
2 6359Post New Informatica Questions
Can anyone tell me the new features in Informatica 9 Version?
Define enterprise data warehousing?
can you please explain me pre session and post session options?
difference between informatica 8.1.1 and 8.6
What do you mean by filter transformation?
What is the function of union transformation?
Differentiate between reusable transformation and mapplet.
How to convert multiple rows to single row (multiple columns) in informatica
Suppose we do not group by on any ports of the aggregator what will be the output?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is InformaticaPowerCenter?
How are indexes created after completing the load process?
Explain joiner transformation in informatica
How to generate sequence numbers without using the sequence generator transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?