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 main advantage of unconnected lookup

Cap Gemini,

2 14451

what is junk dimension

Cap Gemini,

4 7249

what is degenerated dimension

Cap Gemini,

6 9849

what is the purpose of surrogate key and diff between primary key&surrogate key

Cap Gemini,

1 6566

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

Cap Gemini,

9 21416

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

Cap Gemini,

5 9888

how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

TCS,

3 7604

when we create source as oracle and target as flat file, how can i specify first row as column in flat file?

1 5928

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 4789

what is normalization? explain 1st NF, 2nd NF, 3rd NF

SunGard,

1 11556

In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?

6 9328

how will compare two mappings in two different repository?

Real Time, TCS,

2 32134

without using emailtask how will send a mail from informatica?

3 10032

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

IBM, TCS,

5 9105

my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.

TCS,

5 8680

Post New Informatica Questions

Un-Answered Questions { Informatica }

Why do you use Mapping Parameter and mapping variable?

1763

Define joiner transformation?

1049

What is an active transformation?

1110

What is an Integration service in Informatica?

1134

Explain transaction control transformation in informatica

1268

What are the different clients of powercenter?

1060

How to elaborate powercenter integration service?

1133

which one is better performance wise joiner or look up

1093

How identifying bottlenecks in various components of informatica and resolving them?

1132

What is the difference between STOP and ABORT options in Workflow Monitor?

1257

What are the tasks that source qualifier perform?

1106

What is an aggregator transformation?

1096

tell me about your project functionality

2341

What is Data Caches size?

1091

What are the differences between oltp and olap?

972

For More Un-Answered { Informatica } Questions Click Here