Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
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 8602

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

TCS,

2 11686

What are Rapid changing dimensions?

 1 5361

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

Mind Tree,

3 9633

what are objects in data warehouse?

Mind Tree,

2 8273

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

 1 4318

design of staging area?

 1978

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 13894

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

 4 12557

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

TCS,

2012

Which version configuration tool used in ur project?

CTS, TCS,

3192

how you will maintain version?

CTS, TCS,

3 9183

what are 3 tech challenges/ common issues you face?

TCS,

2291

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

IMB, TCS,

2257

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 7095

Post New Informatica Questions

Un-Answered Questions { Informatica }

How do you load alternate records into different tables through mapping flow?

1817

Differentiate between reusable transformation and mapplet.

1045

Explain transaction control transformation in informatica

1222

How to elaborate tracing level?

1125

what is SDLC way of code development?

1981

How to handle decimal places while importing a flatfile into informatica?

1143

What is flashback table ? Advance thanks

1884

Define the various join types of joiner transformation?

956

Mention a few design and development best practices for informatica?

946

Write the unconnected lookup syntax and how to return more than one column.

1066

Explain what are the different versions of informatica?

1046

How do you load unique records into one target table and duplicate records into a different target table?

1178

What are the mapping parameters and mapping variables?

1109

What is the meaning of decode in informatica?

1085

Define joiner transformation?

997

For More Un-Answered { Informatica } Questions Click Here