Follow Our FB Page << >> 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


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


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 ??


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?


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 ?


2 3897

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


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 ?


5 5532

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



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 ?



Post New Informatica Questions

Un-Answered Questions { Informatica }

how tokens will generate?


Explian the Process of deployment groups in informatica


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


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


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


list out all the transformations which use cache?


Target increases every day even though no new record was inserted


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


What are the different types of transformation available in informatica.


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


In warehouses how many schemas are there?


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


Explain the tuning lookup transformation - informatica


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


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