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 14588

what is junk dimension

Cap Gemini,

4 7425

what is degenerated dimension

Cap Gemini,

6 10047

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

Cap Gemini,

1 6687

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 21714

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 10080

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 7734

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

1 6014

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

1 4865

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

SunGard,

1 11647

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

6 9522

how will compare two mappings in two different repository?

Real Time, TCS,

2 32261

without using emailtask how will send a mail from informatica?

3 10177

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 9281

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 8865

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the way to execute pl/sql script using informatica mapping?

1683

Explain target update override in informatica

1190

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1921

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1123

What is a sorter transformation?

1160

In development project what is the process to follow for an etl developer from day1

1760

How do you load only null records into target?

1258

server hot-ws270 is connect to Repository B. What does it mean?

2658

what is unit testing?tell me proceedure

2279

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2410

How will the document be delivered to me?

1131

Could you explain what is enterprise data warehouse?

1229

What is standalone command task?

1376

What do you understand by term role-playing dimension?

1122

Explian the Process of deployment groups in informatica

1102

For More Un-Answered { Informatica } Questions Click Here