Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 6184

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

TCS,

2 9618

What are Rapid changing dimensions?

1 3917

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

Mind Tree,

3 7068

what are objects in data warehouse?

Mind Tree,

2 6181

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

1 3124

design of staging area?

1166

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 10542

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

4 9764

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

TCS,

1240

Which version configuration tool used in ur project?

CTS, TCS,

2337

how you will maintain version?

CTS, TCS,

3 6650

what are 3 tech challenges/ common issues you face?

TCS,

1503

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

IMB, TCS,

1439

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 4883


Post New Informatica Questions






Un-Answered Questions { Informatica }

Define filter transformation?

245


What is target designer and target load order?

250


What is a repository manager?

234


what is diff b/t sorter t/r and agg have the option sorter property...

1300


How to start a workflow using pmcmd command?

273






What do you mean incremental aggregation?

222


Explain the pipeline partition with real time example?

239


What is workflow manager?

213


update strategy transformation in informatica

259


What are the different versions of informatica?

239


What is the use of transformation?

236


What are the different components of powercenter?

214


Is it possible to create multiple domains on a single Informatica server?

282


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

1148


What does update strategy mean, and what are the different option of it?

224