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

Informatica Interview Questions

Questions Answers Views Company eMail

without dynamic lookup how to insert new rows and update existing rows?

HP,

1 5396

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

iNautix,

8 12322

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

Fidelity,

4 8454

Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks

4 8640

What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.

4 7208

Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 7655

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

IBM,

2070

Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

IBM,

1 4204

what is mean by complex business rule ?

Cap Gemini,

2118

In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

Wipro,

1 3558

why union is active transformation?

IBM,

4 7980

how to use incremental load?

TCS,

2 7906

My source table having some records ,i want load 1st record and last record into one target?

iGate,

3 9657

what is incremental aggregation ,with example?

2 9036

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

DELL,

8 13139

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is a repository? And how to add it in an informatica client?

1089

Explain load alternative records / rows into multiple targets - informatica

1105

Describe the impact of several join conditions and join order in a joiner transformation?

1014

What is the advantage of informatica?

1018

What is lookup transformation?

1008

How to call shell scripts from informatica?

940

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1902

How to handle decimal places while importing a flatfile into informatica?

1138

What are the different transaction levels available in transaction control transformation?

1132

What is Index Caches size?

1059

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2101

How to generate sequence numbers using expression transformation?

1036

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?

1009

Plz can any one say me how to get the informatica certification materials and dumps

2009

What is Session and Batches?

1048

For More Un-Answered { Informatica } Questions Click Here