Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

7 9128

what is the architecture of any Data warehousing project?


5 13570

what is the flow?

1 4762

How to load time dimension?


1 11423

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

7 17260

How do you create single lookup transformation using multiple tables?


6 29627

Why touse stored procedure in ETL Application?

2 7631

How to improve the performance of Aggregate transformation?


3 9159

What is critical mapping?

2 7147

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


1 14431

How to view and Generate Metadata Reports?

1 4812

what is difference between COM & DCOM?


1 8274

what is the gap analysis?

1 6394

How to recover sessions in concurrent batches?

3 11008

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


3 19268

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?


What are the types of presistent cache in look up tr.


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?


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


Slowly changing dimensions, types and where will you use them


how tokens will generate?


without table how to come first record only in oracle?


explain one complex mapping with logic? sales project?


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?


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?


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. Thanks in advance


What are the validations that you can perform in oracle and in informatica ? Advance Thanks


Performance tuning in UNIX for informatica mappings?


what is song in infrmatica...?