Informatica Interview Questions
Questions Answers Views Company eMail

Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

Amdocs,

3 16339

What is the difference between warehouse key and surrogate key?

Accenture,

1 5901

what are the limitation of sorter transformation?

TCS,

2 11865

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

Wipro,

4 6925

Why should we use star schema in datawarehouse design?

Wipro,

2 5050

What is the difference between informatica 8.x and 9.x

Wipro,

1 12097

WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...

1 4206

What are the disadvantages of Sequence Generator T/R?

Zensar,

3 14948

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

Amdocs,

1 6041

tell me the push down optimization

Wipro,

2 4817

tell me the informatica architecture

Banca Sella, Wipro,

1 4910

how we can load rejected record's at run time?(not through bad files)

TCS,

1888

what is row level and column level indicator?

TCS,

1 6613

what is the method of error handling when session is running?

TCS,

1 5456

can we use bulk loading when we use look in mapping

TCS,

1 2770


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is session task and command task?

624


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5195


can we override a native sql query within informatica? Where do we do it? How do we do it?

579


Enlist few areas or real-time situations where informatica is required.

570


tell me about your project functionality

1842






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

1715


What does command task mean?

593


explain abt ur project architecture?

1732


How to create or import flat file definition in to the warehouse designer?

587


Explain about Informatica server process that how it works relates to mapping variables?

600


Whats there in global repository

1244


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1909


What is sorter transformation?

556


What do you mean incremental aggregation?

604


Define filter transformation?

601