Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

IBM,

1 6257

I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?

1 3857

How to use Normalizer transformation?

2 5521

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

Accenture, CSC,

3 15338

when we dont use aggregator in mapping ?

CSC,

2 6694

what is workflow varible

HP,

1 6044

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

IBM,

4 18543

If we set dd_insert in mapping and Delete in session properties what will happen.?

IBM,

4 8544

Is it possible to update the target table with PK?

TCS,

1 6527

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 5857

In aggregator if u enable sorted input what will be the output and disable sorted wt is output

6 12875

If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

IBM, TCS,

3 8916

What is target update override

CTS,

2 7668

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

HCL,

5 13419

sorce is a flatfile only 1st and last row should insert to target how will u do?

HCL,

2 9188

Post New Informatica Questions

Un-Answered Questions { Informatica }

How can we update a record in the target table without using update strategy?

1209

Explain in detail about scd type 1 through mapping.

1631

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1342

As union transformation gives UNION ALL output, how you will get the UNION output?

1163

Can informatica load heterogeneous targets from heterogeneous sources?

1239

Whats the difference between informatica powercenter server, repositoryserver and repository?

1223

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1202

How do you load first and last records into target table?

1216

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1067

How is union transformation utilized?

1065

What is informatica powercenter repository?

1263

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2256

What is InformaticaPowerCenter?

1179

What is the difference between a connected look up and unconnected lookup?

1006

What is sq transformation?

1235

For More Un-Answered { Informatica } Questions Click Here