Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

6 3968

what is the architecture of any Data warehousing project?

IBM,

4 7636

what is the flow?

1 1832

How to load time dimension?

Ford,

1 6451

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

5 10654

How do you create single lookup transformation using multiple tables?

TCS,

6 19336

Why touse stored procedure in ETL Application?

2 4847

How to improve the performance of Aggregate transformation?

Dmss,

3 5816

What is critical mapping?

1 4197

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

Accenture,

1 10051

How to view and Generate Metadata Reports?

1 2428

what is difference between COM & DCOM?

Satyam,

1 5926

what is the gap analysis?

1 4209

How to recover sessions in concurrent batches?

2 7367

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

TCS,

3 14727


Post New Informatica Questions


Un-Answered Questions { Informatica }

What is Cognos script editor?

2489


in reporting we add some new objects,how we get the count of the newly added objects to the report

704


How to load query faster,so that It will take less time to load?

295


 Informatica Checkpoints

1613


my source is junk data how will u remove that junk data by using unix please any one replay me

2035


Have you worked with/created Parameter file

204


How many transformations can be used in mapplets.

206


A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

362


How do you recover rows from a failed session

269


Why do you use Mapping Parameter and mapping variable?

215


How to Migrate the UNIX SCRIPTS from SIT TO PROD?

461


What are session parameters ? How do you set them?

209


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

3918


Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai

1172


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

398