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 20143

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

TCS,

5 10254

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

TCS,

4 8269

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 7844

Can we use unconnected lookup as dynamic lookup?

ITC Infotech, TCS, Wipro,

5 17849

how did u understand business requirement?

TCS,

2 5928

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

TCS,

2437

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

HG, UST,

4 20102

can we use mapplet as starting n ending object in mapping

TCS,

2 5893

what is the predefined port in dynamic lookup

2 6248

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 7264

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

Zensar,

4152

What is the difference between SOURCE and TARGET BASED COMMITS?

IBM,

3 6870

What happens if we dont select data driven option?

Zensar,

2 7809

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,

2059

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the scenario which compels informatica server to reject files?

1126

What are the differences between a connected lookup and unconnected lookup?

1128

Define Pmrep command?

1118

If informatica has its scheduler why using third party scheduler?

1310

What is the use of target designer?

1123

How an expression transformation differs from aggregator transformation?

1091

Enlist the various types of transformations.

1124

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1313

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

1174

Differentiate between a database and data warehouse?

1194

What is workflow monitor?

1103

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2305

What is meant by query override?

1118

What are the different clients of powercenter?

1118

What is the command used to run a batch?

1115

For More Un-Answered { Informatica } Questions Click Here