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

Informatica Interview Questions

Questions Answers Views Company eMail

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

L&T,

7 13841

i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

L&T,

5 12373

if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

BirlaSoft, Genpact, L&T, Syntel,

9 17052

can we see default group,when we use router?if yes how?

L&T,

2 7501

what is left outer join?

L&T,

3 8448

when we use dynamic lookup,if condition matches what will be the o/p?

L&T,

2 8383

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

L&T,

5 12562

in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

L&T,

11 34480

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

CTS, Wipro,

6 11058

Target is zero file and how can you send the email?

Bank Of America,

2 11779

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?

8 18954

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you

Patni,

5 9987

how to remove staging area

1 5601

When we are using Dynamic Cache,which options we will select in session level?

Cognizant, CTS,

1 4541

h0w many versions have been developed of onformatica so far?

TCS, TetraSoft,

1 3088

Post New Informatica Questions

Un-Answered Questions { Informatica }

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2131

Quickly characterize reusable change?

1119

How to go to the older version for a mapping?

1098

How can we improve session performance in aggregator transformation?

1117

What are the performance considerations when working with aggregator transformation?

1152

What are the types of data warehouses?

1526

How we can create indexes after completing the load process?

1160

What is domain and gateway node?

1165

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1100

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1052

What is Index Caches size?

1115

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8223

Can we change Dynamic to Static or Persistent cache? If so what happens?

2210

What is informatica?

1155

How an expression transformation differs from aggregator transformation?

1043

For More Un-Answered { Informatica } Questions Click Here