Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

6 7533

what is the architecture of any Data warehousing project?

IBM,

4 11523

what is the flow?

1 3852




How to load time dimension?

Ford,

1 9949

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

7 15199

How do you create single lookup transformation using multiple tables?

TCS,

6 26439

Why touse stored procedure in ETL Application?

2 6774

How to improve the performance of Aggregate transformation?

Dmss,

3 8070




What is critical mapping?

2 6243

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

Accenture,

1 13127

How to view and Generate Metadata Reports?

1 4100

what is difference between COM & DCOM?

Satyam,

1 7640

what is the gap analysis?

1 5775

How to recover sessions in concurrent batches?

3 9919

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

TCS,

3 17794


Post New Informatica Questions






Un-Answered Questions { Informatica }

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

1309


How do you use reject loader.

920


in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

1042


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

681


h0w many versions have been developed of onformatica so far?

867


Explain Dataware house architecture .how data flow from intial to end?

1133


draw informatica architecture 8.6 ?

2627


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

580


what is mean by complex business rule ?

761


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

763


what is hash table in informatica?

3551


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

283


What are the new features of Power Center 5.0?

343


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

821


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

860