Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

7 9839

what is the architecture of any Data warehousing project?

IBM,

5 14342

what is the flow?

1 5110




How to load time dimension?

Ford,

1 11960

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

7 18204

How do you create single lookup transformation using multiple tables?

TCS,

6 31166

Why touse stored procedure in ETL Application?

2 7965

How to improve the performance of Aggregate transformation?

Dmss,

3 9609




What is critical mapping?

2 7560

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

Accenture,

1 14994

How to view and Generate Metadata Reports?

1 5171

what is difference between COM & DCOM?

Satyam,

1 8486

what is the gap analysis?

1 6591

How to recover sessions in concurrent batches?

3 11482

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

TCS,

3 19806


Post New Informatica Questions






Un-Answered Questions { Informatica }

server hot-ws270 is connect to Repository B. What does it mean?

1119


What is rank index in rank transformation?

17


What do mean by local and global repository?

32


What is aggregate cache in aggregator transformation?

36


What is native users?

29






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

941


Explain lookup transformation is active in informatica

46


Enterprise data warehouse your projects phase by phase explain?

819


How to create or import flat file definition in to the warehouse designer?

47


How do you update the records with or without using update strategy?

9


What is Session and Batches?

42


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

25


Describe expression transformation?

14


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

8


What do you understand by a term domain?

25