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 ?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?2 10649
hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.
Hi 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 : email@example.com TIA , Sagar1764
What 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 advance3 5440
Source 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 8219
I 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?
I 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 5293
lookup transformation with screenshots
Using Connected or unconnected lookup for performance wise which one is preferable?.
What is event and what are the tasks related to it?
have u done any performance tuning? how u ll do?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is union transformation?
What is the status code in stored procedure transformation?
Explain the types of transformations?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? firstname.lastname@example.org
4 yrs etl devloper roles and responsibilities?any body give solutions
What the difference is between a database, a data warehouse and a data mart?
What is the function of aggregator transformation?
Explain the difference between mapping parameter and mapping variable?
Write the different tools in the workflow manager?
How does the aggregator transformation handle null values?