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

Informatica Interview Questions

Questions Answers Views Company eMail

checkout and checkin in informatica 8.6

TCS,

3 19809

How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)

TCS,

5 9882

How to Join Tables my Source is having 15 table target is one?

TCS,

4 7915

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

TCS,

2 7603

Can we use unconnected lookup as dynamic lookup?

ITC Infotech, TCS, Wipro,

5 17465

how did u understand business requirement?

TCS,

2 5702

What is the difference between writing a joiner query in ANSI style and THETA style?

TCS,

2338

Why we select the table which has minimum number of records as Master table in joiner?

HG, UST,

4 19693

can we use mapplet as starting n ending object in mapping

TCS,

2 5693

what is the predefined port in dynamic lookup

2 5989

my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

Zensar,

2 7033

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

Zensar,

4055

What is the difference between SOURCE and TARGET BASED COMMITS?

IBM,

3 6612

What happens if we dont select data driven option?

Zensar,

2 7546

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

IBM, TCS,

1941

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the need of etl tools?

1066

What is a filter transformation and why it is an active one?

917

How do you use reject loader.

2552

Make a note of the quantity vaults made in informatica?

949

What are the measure objects?

1126

What is session task and command task?

1196

What are mapplets?

1220

Where can we find the throughput option in informatica?

1011

What is the way to execute pl/sql script using informatica mapping?

1527

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

1098

how to load rows into fact table in data warehouse

1126

What is powercenter on grid?

1135

Explain the aggregator transformation?

1102

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2087

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

992

For More Un-Answered { Informatica } Questions Click Here