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 43981

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 3417

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 4696

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 10814

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

6 10656

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

IBM,

1 7007

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 10651

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 4191

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

2 7194

How union transformation is active ?

Puma,

2 5836

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

Puma,

7 10388

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 10477

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

Puma,

5 8798

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

Puma,

2041

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,

2144

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is workflow monitor?

1014

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

7946

What is target designer and target load order?

1057

what is size of u r database?

2266

What is difference between a gateway node and worker node?

1085

Explain Dataware house architecture .how data flow from intial to end?

2554

What are mapplets?

1226

What is data transformation manager process?

1106

Which transformation should we use to normalise the COBOL and relational sources?

1156

Can we override a native sql query within informatica?

999

What are the types of presistent cache in look up tr.

2025

What are batches?

1032

How to load data in informatica ?

971

Please let me know how to make Data masking in informatica..

1679

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

1105

For More Un-Answered { Informatica } Questions Click Here