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 14444

what is junk dimension

Cap Gemini,

4 7239

what is degenerated dimension

Cap Gemini,

6 9842

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

Cap Gemini,

1 6555

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 21392

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 9881

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 7596

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

1 5916

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

1 4783

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

SunGard,

1 11548

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

6 9321

how will compare two mappings in two different repository?

Real Time, TCS,

2 32121

without using emailtask how will send a mail from informatica?

3 10028

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 9102

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 8673

Post New Informatica Questions

Un-Answered Questions { Informatica }

How big was your fact table

1797

What is update strategy transform?

1096

What is the advantage of informatica?

1065

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1506

What is decode in static cache?

1173

Explain target update override in informatica

1122

What is persistent lookup cache?

1028

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

969

EXL informatica Questions

1384

What is a predefined event?

1087

What is the need for an etl tool?

1064

How can you define user defied event?

1026

What are the new features of informatica 9.x developer?

968

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1089

What is an expression transformation?

1010

For More Un-Answered { Informatica } Questions Click Here