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

Informatica Interview Questions

Questions Answers Views Company eMail

difference between informatica 8.6 and 9

Atos Origin, BA Continnum Solutions, Core Logic,

3 44113

I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?

Franklin Templeton,

1 3501

My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

TCS,

1 4791

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

HP,

8 11089

what is mean by flag 4 in update strategy t/r

6 10871

I want skip first 5 rows to load in to target? what will be the logic at session level ??

IBM,

1 7091

i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

IBM, TCS,

7 10882

if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 4270

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

2 7333

How union transformation is active ?

Puma,

2 5936

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

Puma,

7 10621

Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?

Cap Gemini, Puma, Wipro,

3 10616

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

Puma,

5 8981

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

Puma,

2078

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

Puma,

2186

Post New Informatica Questions

Un-Answered Questions { Informatica }

Is it possible to revert a global repository to local one and why?

1086

Global and Local shortcuts. Advantages.

2037

can we override a native sql query within informatica? Where do we do it?

1129

What are the different options available for update strategy?

1005

What is a snowflake schema?

999

What is the difference between informatics 7x and 8x and what is latest version?

1087

 Informatica Checkpoints

3334

What is a code page?

1182

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2268

What all join we can perform in LOOKUP transformation?

986

What is Session and Batches?

1111

How many types of sessions are there in informatica.please explain them?

1171

What is the way to execute pl/sql script using informatica mapping?

1617

What does refresh system mean, and what are its distinctive choice?

1187

How can you validate all mappings in the repository simultaneously?

1375

For More Un-Answered { Informatica } Questions Click Here