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 5485

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 12596

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 8615

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

4 8834

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 7374

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

4 7827

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

IBM,

2122

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 4283

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 3670

why union is active transformation?

IBM,

4 8180

how to use incremental load?

TCS,

2 8060

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

iGate,

3 9813

what is incremental aggregation ,with example?

2 9179

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

DELL,

8 13378

Post New Informatica Questions

Un-Answered Questions { Informatica }

Informatica settings are available in which file?

990

What is meant by lookup transformation?

1110

Explain pushdown optimization and types in informatica

1077

draw informatica architecture 8.6 ?

3871

What is the format of informatica objects in a repository?

1019

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1100

What are the designer tools for creating transformations?

1118

Which is the t/r that builts only single cache memory?

1190

How can you validate all mappings in the repository simultaneously?

1371

Do you find any difficulty while working with flat files as source and target?

1098

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2365

Mention few power centre client applications with their basic purpose?

951

Can informatica load heterogeneous targets from heterogeneous sources?

1187

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

2379

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2057

For More Un-Answered { Informatica } Questions Click Here