Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

If I have a index defined on target table and if set it to bulk load will it work ?

IBM,

4 12655

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 14584

Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

IBM,

11 13011

how can we check whether a particular cache is static or dynamic?

InfoCepts, TCS,

1 6275

Can any one explain or sujjest some sites for scd mappings.Thank you

Wipro,

1 3554

Difference between session variables and workflow variables?

Informatica,

2 17289

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.

TCS,

5 4967

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 : sagardev7@gmail.com TIA , Sagar

1764

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 advance

3 5440

how many data models u have done in informatica project?

TCS,

2 6290

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?

TCS,

6 6949

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?

Ness Technologies,

2 5293

How can we get two output ports in un-connect transformation?

Ness Technologies,

2 5510


Post New Informatica Questions






Un-Answered Questions { Informatica }

lookup transformation with screenshots

3143


Using Connected or unconnected lookup for performance wise which one is preferable?.

558


What is event and what are the tasks related to it?

169


have u done any performance tuning? how u ll do?

1403


What is the difference between writing a joiner query in ANSI style and THETA style?

1470






What is union transformation?

184


What is the status code in stored procedure transformation?

240


Explain the types of transformations?

173


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1035


4 yrs etl devloper roles and responsibilities?any body give solutions

1107


What the difference is between a database, a data warehouse and a data mart?

177


What is the function of aggregator transformation?

201


Explain the difference between mapping parameter and mapping variable?

198


Write the different tools in the workflow manager?

178


How does the aggregator transformation handle null values?

181