Informatica Interview Questions
Questions Answers Views Company eMail

What is souce qualifier transformation it is active or passive

HCL,

2 9141

What is an aggregator transformation? it is active why cant it be passive explain?

HCL,

3 16616

Diffrence between 7.1,8.1 and 8.6

HCL, Wipro,

3 10687

How the dimensions will be loaded?

HCL,

1605

How the facts will be loaded? explain

HCL,

2 6942

What is partioning?how many types of partinings are there

HCL,

2 6484

how can one come to know wether the records loak into the target if we use update strategy

Wipro,

1 4460

how can one eliminate dupliacte data with out using distinct option?

Patni, Wipro,

5 9012

SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?

IBM,

6 8565

Roles and Responsibilties of Informatica Production Support Member?

6 54652

What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?

CTS, Wipro,

11975

what is sql override?what is the use of it?

Sonata,

4 14264

can every transfomation reusable?how?

Wipro,

2 6426

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

Sonata,

2 5297

how can u avoid duplicate rows in flat file?

CTS, Wipro,

4 9121


Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the tuning techniques you applied during your last project

1544


Explain why we use partitioning the session in informatica?

589


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6425


What is the difference between stop and abort in informatica

633


How can we store previous session logs?

544






What is joiner transformation?

562


What is data transformation manager process?

601


can we override a native sql query within informatica? How do we do it?

624


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1023


Under what conditions selecting sorted input in aggregator will still not boost session performance?

608


What is the difference between source qualifier transformations source filter to filter transformation?

553


How to create a non-reusable instance of reusable transformations?

654


How to use procedural logic inside infromatica?

606


What is informatica? Why do we need it?

612


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1509