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

Informatica Interview Questions

Questions Answers Views Company eMail

what is the need of session partitioning... how it is useful in real time

Amazon,

3 8759

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

IBM,

1 5203

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

IBM,

1 5119

What is diff between connected and unconnected lookup?

BirlaSoft, Blue Star Infotech,

5 9003

What is diff joiner and lookup

BirlaSoft,

4 8619

what is mapping parameter and mapping variables

BirlaSoft,

1 5196

if i am having 10 records in source, i want 20 records in target...how will you do it

BirlaSoft, IBM,

13 18608

without matching columns in two tables. how can you join

BirlaSoft,

5 11527

how to call lookup qualifer in unconnected look;up

BirlaSoft,

1 5674

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2517

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

Span Systems,

5 8321

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?

Span Systems,

3 6384

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

Span Systems,

2 5126

how to design mapping half of source table records into one target and remaining half into another target

ABC,

8 15339

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 6933

Post New Informatica Questions

Un-Answered Questions { Informatica }

what is the Default Source Option For Update Strategy Transformation?

1239

Which development components of informatica have the highest usage?

1041

What's the layout of parameter file (what does a parameter file contain?)?

2385

Performance tuning( what you did in performance tuning)

1983

What is sequence generator transformation in informatica?

1078

What is rank index in rank transformation?

1079

What is update strategy transform?

1101

What are the different lookup cache(s)?

1118

can anyone suggest best free Talend data integration training online

1690

What are the informatica performance improvement tips

1093

How to extract the informatica rejected data?

1219

What is the command used to run a batch?

1062

What are active transformations.

1654

Explain in detail scd type 2 through mapping.

1041

How can you increase the performance in joiner transformation?

1190

For More Un-Answered { Informatica } Questions Click Here