Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

6 5846

what is the architecture of any Data warehousing project?

IBM,

4 9607

what is the flow?

1 2753




How to load time dimension?

Ford,

1 8260

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

7 13163

How do you create single lookup transformation using multiple tables?

TCS,

6 23096

Why touse stored procedure in ETL Application?

2 5889

How to improve the performance of Aggregate transformation?

Dmss,

3 6905




What is critical mapping?

2 5134

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

Accenture,

1 11578

How to view and Generate Metadata Reports?

1 3312

what is difference between COM & DCOM?

Satyam,

1 6763

what is the gap analysis?

1 4985

How to recover sessions in concurrent batches?

3 8775

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

TCS,

3 16295


Post New Informatica Questions






Un-Answered Questions { Informatica }

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?

476


waht type of interface is used for testing the data in informatica

742


what is the difference between informatica6.1 and infomatica7.1

582


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

616


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

2901


what are factless facts? And in which scenario will you use such kinds of fact tables.

292


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

588


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

544


what is the size of your data warehousing?

580


can any one give some examples for pre sql and post sql(Except dropping and creating index).

2314


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

612


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

516


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

962


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

4218


explain about unit testing? in real time?

557