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 6089

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 3695

How to use Normalizer transformation?

2 5295

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

Accenture, CSC,

3 15075

when we dont use aggregator in mapping ?

CSC,

2 6518

what is workflow varible

HP,

1 5868

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

IBM,

4 18196

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

IBM,

4 8232

Is it possible to update the target table with PK?

TCS,

1 6363

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

2 5642

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

6 12489

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 8652

What is target update override

CTS,

2 7443

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 12961

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

HCL,

2 9002

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the uses of etl tools?

1083

What is complex mapping?

1079

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1210

In informatics server which files are created during the session rums?

1086

Explain dynamic target flat file name generation in informatica

1021

What is the commit type if you have a transaction control transformation in the mapping?

987

What is the function of union transformation?

1081

explain one complex mapping with logic? sales project?

6623

How you prepared reports for OLAP?

1566

What is the reusable transformation?

1019

I have a flat file, want to reverse the contents of the flat file

1078

Explain the informatica workflow?

1021

Which transformation is needed while using the Cobol sources as source definitions?

1141

How to generate sequence numbers without using the sequence generator transformation?

1150

What is different between the data warehouse and data mart?

1018

For More Un-Answered { Informatica } Questions Click Here