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 5498

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 12620

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 8631

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

4 8849

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 7389

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

4 7837

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

IBM,

2128

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 4288

what is mean by complex business rule ?

Cap Gemini,

2162

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

Wipro,

1 3682

why union is active transformation?

IBM,

4 8203

how to use incremental load?

TCS,

2 8069

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

iGate,

3 9823

what is incremental aggregation ,with example?

2 9198

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

DELL,

8 13390

Post New Informatica Questions

Un-Answered Questions { Informatica }

What can we do to improve the performance of informatica aggregator transformation?

1097

how we can load rejected record's at run time?(not through bad files)

2384

What is the difference between router and filter?

1276

What is informatica powercenter repository?

1206

Which development components of informatica have the highest usage?

1056

What are mapplets? How is it different from a Reusable Transformation?

1096

How to load a Dimension ? and how to load a fact table?

1423

How to improve the performance of a session using sorter transformation?

1150

explan ur project architecture?

2075

What are Dimensional table?

1063

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1134

without table how to come first record only in oracle?

2260

Explain pushdown optimization and types in informatica

1082

In how many ways we can create ports?

1126

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1587

For More Un-Answered { Informatica } Questions Click Here