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 19967

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

TCS,

5 10075

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

TCS,

4 8099

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 7718

Can we use unconnected lookup as dynamic lookup?

ITC Infotech, TCS, Wipro,

5 17666

how did u understand business requirement?

TCS,

2 5835

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

TCS,

2380

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

HG, UST,

4 19902

can we use mapplet as starting n ending object in mapping

TCS,

2 5801

what is the predefined port in dynamic lookup

2 6123

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 7150

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

Zensar,

4109

What is the difference between SOURCE and TARGET BASED COMMITS?

IBM,

3 6762

What happens if we dont select data driven option?

Zensar,

2 7659

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,

2008

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is workflow? What are the components of workflow manager?

1177

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2036

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1052

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

2251

What is the surrogate key?

1261

Explain about cumulative Sum or moving sum?

1043

How to update a particular record in target with out running whole workflow?

1576

Partition, what happens if the specified key range is shorter and longer

2499

How many ways are there to do 'remove duplicate records in informatica'?

1014

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1079

What is a snowflake schema?

995

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7186

What you know about transaction control transformation?

995

What is an active transformation?

1110

What is joiner change?

1147

For More Un-Answered { Informatica } Questions Click Here