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 44095

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 3491

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 4782

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 11065

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

6 10861

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

IBM,

1 7084

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 10862

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 4264

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

2 7319

How union transformation is active ?

Puma,

2 5924

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

Puma,

7 10600

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 10608

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

Puma,

5 8964

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

Puma,

2075

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,

2184

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain how to import oracle sequence into informatica?

1011

How can we improve session performance in aggregator transformation?

1117

What is a surrogate key?

1080

Which transformation is needed while using the Cobol sources as source definitions?

1174

Name the different lookup cache(s)?

1234

Is there any target staging area in informatica not staging area

2578

How to go to the older version for a mapping?

1098

What are the advantages of using informatica as an etl tool over teradata?

1022

What are the tuning techniques you applied during your last project

2026

Define mapping and session?

1033

Explain what are the different versions of informatica?

1097

How to convert multiple rows to single row (multiple columns) in informatica

1380

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1068

What is a sequence generator transformation?

1021

What is decode in static cache?

1179

For More Un-Answered { Informatica } Questions Click Here