Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

7 8899

what is the architecture of any Data warehousing project?

IBM,

5 13301

what is the flow?

1 4661




How to load time dimension?

Ford,

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?

TCS,

6 29294

Why touse stored procedure in ETL Application?

2 7546

How to improve the performance of Aggregate transformation?

Dmss,

3 9024




What is critical mapping?

2 7038

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

Accenture,

1 14257

How to view and Generate Metadata Reports?

1 4735

what is difference between COM & DCOM?

Satyam,

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 ?

TCS,

3 19119


Post New Informatica Questions






Un-Answered Questions { Informatica }

How many transformations can be used in mapplets.

715


h0w many versions have been developed of onformatica so far?

1040


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

795


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?

686


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

866






what are 3 tech challenges/ common issues you face?

1154


what is the complex transformation you used in informatica

1404


permutations of mapplet

1223


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

1221


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?

1061


difference between informatica 8.1.1 and 8.6

2509


expain about the tune parameters?

1067


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

3386


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

894


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

801