Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

difference between informatica 8.6 and 9

Atos Origin, BA Continnum Solutions, Core Logic,

3 40865

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 2052

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 3149

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 6458

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

6 7282

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

IBM,

1 5150

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 6302

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 2650

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

2 5194

How union transformation is active ?

Puma,

2 3897

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

Puma,

7 5954

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 7638

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

Puma,

5 5532

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

Puma,

1210

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,

1247


Post New Informatica Questions






Un-Answered Questions { Informatica }

how tokens will generate?

1261


Explian the Process of deployment groups in informatica

194


Using Connected or unconnected lookup for performance wise which one is preferable?.

510


State the limitations where we cannot use joiner in the mapping pipeline?

141


How do you promote a non-reusable transformation to reusable transformation?

188






list out all the transformations which use cache?

179


Target increases every day even though no new record was inserted

526


what is diff b/t sorter t/r and agg have the option sorter property...

1224


What are the different types of transformation available in informatica.

156


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

1134


In warehouses how many schemas are there?

156


How can repository reports be accessed without sql or other transformations?

144


Explain the tuning lookup transformation - informatica

172


Can anyone tell me the new features in Informatica 9 Version?

1096


What is a shortcut and copy in Informatica and how two are different with each other?

178