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 5571

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 12898

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 8758

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

4 9000

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 7570

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

4 7971

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

IBM,

2192

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 4356

what is mean by complex business rule ?

Cap Gemini,

2221

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

Wipro,

1 3761

why union is active transformation?

IBM,

4 8368

how to use incremental load?

TCS,

2 8169

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

iGate,

3 9924

what is incremental aggregation ,with example?

2 9313

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

DELL,

8 13671

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2133

What are the main issues while working with flat files as source and as targets ?

1227

Why do we need informatica?

1054

What is the fact table?

1142

How do you load alternate records into different tables through mapping flow?

1929

Explain transaction control transformation in informatica

1312

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1532

Enlist the tasks for which source qualifier transformation is used.

1075

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

2026

What is meant by incremental aggregation?

1187

What is persistent lookup cache?

1101

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1081

What are active transformations.

1704

wat are deployement groups in informatica, how it will be used for developers

1777

How to call shell scripts from informatica?

1045

For More Un-Answered { Informatica } Questions Click Here