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

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

Question Posted / natrajdreams

Answers were Sorted based on User's Feedback



Hi , Please help how to achieve the following scenario. I have a source table like this. Ro..

Answer / rakesh

To append the data, Union Transformation is required. Both sources have same layout, they are input to Union Transformation and the desired output can be obtained.

Is This Answer Correct ?    0 Yes 0 No

Hi , Please help how to achieve the following scenario. I have a source table like this. Ro..

Answer / harleen

The question needs to be corrected.I think there are 3 rows already in the target and only one row has to be inserted.
The same can be done by 2 ways

1)Update strategy (Update as Insert)

2)Dynamic lookup

Is This Answer Correct ?    1 Yes 2 No

Hi , Please help how to achieve the following scenario. I have a source table like this. Ro..

Answer / abhinaw prakash

You can implement the same using SCD 1.

Please let me know if you have any doubt.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

What do you mean by worklet?

0 Answers  

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  

What are the joiner caches?

3 Answers   Informatica,

How many repositories can we create in Informatica?

3 Answers  

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  

what is materialized view?

2 Answers  

Why the workflow is failed after running two hours in informatica?

1 Answers   GE,

what are the transformations that restricts the partitioning of sessions?

1 Answers  

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

what is degenerated dimension

6 Answers   Cap Gemini,

How to do unit testing in informatica? How to load data in informatica ?

0 Answers  

For more Informatica Interview Questions Click Here
Categories