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 5382

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 3083

How to use Normalizer transformation?

2 4413

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

Accenture, CSC,

3 13806

when we dont use aggregator in mapping ?

CSC,

2 5605

what is workflow varible

HP,

1 5165

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

IBM,

4 16713

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

IBM,

4 6756

Is it possible to update the target table with PK?

TCS,

1 5583

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

2 4733

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

6 10435

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 7668

What is target update override

CTS,

2 6557

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 11033

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

HCL,

2 7809


Post New Informatica Questions

Un-Answered Questions { Informatica }

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

621


Explain what transformation and how many are there in informatica?

476


What are data-driven sessions?

705


Explain the aggregator transformation?

616


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3492






what is the size ur source like(file system or database)? how many record daily come u r banking project?

1740


How to load a Dimension ? and how to load a fact table?

941


What is the sequence generator transformation in informatica?

603


On which transformations you created partitions in your project?

750


What do you mean by channel change?

529


How an expression transformation differs from aggregator transformation?

612


What is domain in terms of informatica?

555


What is a filter transformation?

555


what is mean by complex business rule ?

1710


Explain the types of lookup transformation?

551