Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

6 5281

what is the architecture of any Data warehousing project?

IBM,

4 9047

what is the flow?

1 2493




How to load time dimension?

Ford,

1 7720

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

7 12529

How do you create single lookup transformation using multiple tables?

TCS,

6 22066

Why touse stored procedure in ETL Application?

2 5649

How to improve the performance of Aggregate transformation?

Dmss,

3 6541




What is critical mapping?

1 4845

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

Accenture,

1 11127

How to view and Generate Metadata Reports?

1 3059

what is difference between COM & DCOM?

Satyam,

1 6568

what is the gap analysis?

1 4781

How to recover sessions in concurrent batches?

3 8382

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

TCS,

3 15875


Post New Informatica Questions






Un-Answered Questions { Informatica }

Enterprise data warehouse your projects phase by phase explain?

432


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4338


Can we change Dynamic to Static or Persistent cache? If so what happens?

559


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

901


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

4051


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

550


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

537


what is index?how it can work in informatica

530


What are the new features of Power Center 5.0?

197


What is the meaning of up gradation of repository?

288


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

128


my source is junk data how will u remove that junk data by using unix please any one replay me

2109


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

521


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

4446


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

507