Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

7 9128

what is the architecture of any Data warehousing project?

IBM,

5 13570

what is the flow?

1 4762




How to load time dimension?

Ford,

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?

TCS,

6 29627

Why touse stored procedure in ETL Application?

2 7631

How to improve the performance of Aggregate transformation?

Dmss,

3 9159




What is critical mapping?

2 7147

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

Accenture,

1 14431

How to view and Generate Metadata Reports?

1 4812

what is difference between COM & DCOM?

Satyam,

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 ?

TCS,

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?

708


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

829


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

560


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

883


Slowly changing dimensions, types and where will you use them

559






how tokens will generate?

1028


without table how to come first record only in oracle?

1167


explain one complex mapping with logic? sales project?

4229


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

330


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?

1013


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?

1074


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

952


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

973


Performance tuning in UNIX for informatica mappings?

1409


what is song in infrmatica...?

975