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 5398

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 12329

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 8458

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

4 8644

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 7212

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

4 7657

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 4208

what is mean by complex business rule ?

Cap Gemini,

2121

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

Wipro,

1 3560

why union is active transformation?

IBM,

4 7981

how to use incremental load?

TCS,

2 7910

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

iGate,

3 9662

what is incremental aggregation ,with example?

2 9043

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

DELL,

8 13143

Post New Informatica Questions

Un-Answered Questions { Informatica }

Enlist the advantages of informatica.

1014

What is source qualifier transformation in informatica?

953

Write the advantages of partitioning a session?

1222

What are the reusable transformations?

1105

What do mean by local and global repository?

1167

What is the scenario which compels informatica server to reject files?

1017

How union transformation is used?

968

Explain the scenario which compels informatica server to reject files?

1097

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2193

What is an Integration service in Informatica?

1089

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1051

To import the flat file definition into the designer where should the flat file be placed?

1016

Design a mapping to load a target table with the following values from the above source?

1297

What is xml source qualifier transformation in informatica?

1184

Name the different lookup cache(s)?

1168

For More Un-Answered { Informatica } Questions Click Here