Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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 15591

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 17520

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

IBM,

11 19016

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

InfoCepts, TCS,

1 8238

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

Wipro,

1 4949

Difference between session variables and workflow variables?

Informatica,

2 20608

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 13267

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

TCS,

5 8096

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

2744

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 8080

how many data models u have done in informatica project?

TCS,

2 8276

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 11441

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 10898

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 7415

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

Ness Technologies,

2 7468

Post New Informatica Questions

Un-Answered Questions { Informatica }

Enlist the advantages of informatica.

1068

How to create the source and target database connections in server manager?

1090

Under what condition selecting sorted input in aggregator may fail the session?

1125

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1900

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1077

Where are the source flat files kept before running the session?

1074

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1125

How to load a Dimension ? and how to load a fact table?

1416

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1132

Enlist the various types of transformations.

1057

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6177

Explain the etl program with few examples.

1048

How many dimensions are there in informatica?

1085

What are the types of caches in lookup? Explain them.

969

What is primary and backup node?

1127

For More Un-Answered { Informatica } Questions Click Here