Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

7 10061

what is the architecture of any Data warehousing project?

IBM,

5 14557

what is the flow?

1 5184




How to load time dimension?

Ford,

1 12119

In update strategy target table or flat file which gives more performance ? why?

7 18521

How do you create single lookup transformation using multiple tables?

TCS,

6 31541

Why touse stored procedure in ETL Application?

2 8071

How to improve the performance of Aggregate transformation?

Dmss,

3 9759




What is critical mapping?

2 7690

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

Accenture,

1 15166

How to view and Generate Metadata Reports?

1 5253

what is difference between COM & DCOM?

Satyam,

1 8546

what is the gap analysis?

1 6661

How to recover sessions in concurrent batches?

3 11646

what are the different types of transformation available in informatica and what are the mostly used ?

TCS,

3 19941


Post New Informatica Questions






Un-Answered Questions { Informatica }

What are the measure objects?

63


generate date / time dimension in informatica

69


What is target designer and target load order?

42


Enterprise data warehouse your projects phase by phase explain?

847


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

3599






How to handle decimal places while importing a flatfile into informatica?

44


What is Cognos script editor?

3158


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

34


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1153


What are the basic requirements to join two sources in a source qualifier transformation using default join?

65


What are the guidelines to be followed while using union transformation?

73


What is the difference between stop and abort in informatica

56


Parameter and variable differences

976


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

1180


What is sorter transformation?

31