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

Informatica Interview Questions

Questions Answers Views Company eMail

After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

TCS,

3 8748

In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.

TCS,

2 11813

What are Rapid changing dimensions?

1 5423

How to load only the first and last record of a flat file into the target?

Mind Tree,

3 9787

what are objects in data warehouse?

Mind Tree,

2 8401

what are challenges that you faced in testing? give solution to it?

1 4388

design of staging area?

2030

Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 14046

Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 12703

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

TCS,

2058

Which version configuration tool used in ur project?

CTS, TCS,

3258

how you will maintain version?

CTS, TCS,

3 9298

what are 3 tech challenges/ common issues you face?

TCS,

2346

have u done any performance tuning? how u ll do?

IMB, TCS,

2299

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

NTT Data,

3 7231

Post New Informatica Questions

Un-Answered Questions { Informatica }

Informatica settings are available in which file?

990

What are the steps involved in the migration from older version to newer version of Informatica Server?

2109

Where is metadata stored?

1113

Describe the impact of several join conditions and join order in a joiner transformation?

1063

Explain about cumulative Sum or moving sum?

1043

Write the advantages of partitioning a session?

1282

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

1203

in reporting we add some new objects,how we get the count of the newly added objects to the report

2193

where to store informatica rejected data? How to extract the informatica rejected data?

1005

Differentiate between joiner and lookup transformation?

1102

Differentiate between a repository server and a powerhouse?

1118

Define joiner transformation?

1049

Scheduling properties,whats the default (sequential)

1955

What is domain in terms of informatica?

1007

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4727

For More Un-Answered { Informatica } Questions Click Here