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 44237

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 3570

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 4862

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 11331

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

6 11066

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

IBM,

1 7176

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 11113

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 4367

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

2 7451

How union transformation is active ?

Puma,

2 6032

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

Puma,

7 10829

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 10761

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

Puma,

5 9153

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

Puma,

2132

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,

2250

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the limitations of joiner transformation?

1182

What does “tail –f” command do and what is its use as an Informatica admin.

1147

How does the aggregator transformation handle null values?

1197

What does update strategy mean, and what are the different option of it?

1143

Clarify the utilization of aggregator cache record?

1045

Which are the different editions of informatica powercenter that are available?

1084

What is the reusable transformation?

1104

Define joiner transformation?

1107

How can informatica be used for an organization?

1276

How can we store previous session logs?

1140

State the differences between sql override and lookup override?

1290

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1821

Explain lookup transformation source types in informatica

1157

What is informatica worklet?

1118

what is song in infrmatica...?

2327

For More Un-Answered { Informatica } Questions Click Here