Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

7 8899

what is the architecture of any Data warehousing project?


5 13301

what is the flow?

1 4661

How to load time dimension?


1 11262

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

7 17007

How do you create single lookup transformation using multiple tables?


6 29294

Why touse stored procedure in ETL Application?

2 7546

How to improve the performance of Aggregate transformation?


3 9024

What is critical mapping?

2 7038

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


1 14257

How to view and Generate Metadata Reports?

1 4735

what is difference between COM & DCOM?


1 8208

what is the gap analysis?

1 6303

How to recover sessions in concurrent batches?

3 10839

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


3 19119

Post New Informatica Questions

Un-Answered Questions { Informatica }

How many transformations can be used in mapplets.


h0w many versions have been developed of onformatica so far?


hi real timers . iam waiting for ur reply regarding ETL TESTING


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?


if we have a delimiters at unwanted places in a flat file how can we over come those.


what are 3 tech challenges/ common issues you face?


what is the complex transformation you used in informatica


permutations of mapplet


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


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?


difference between informatica 8.1.1 and 8.6


expain about the tune parameters?


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


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks


what is the end to end process meaning in my project(my project is development)and functionality plz tell me