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 is the term PIPELINE in informatica ?

7 Answers   Deloitte,

What is meant by incremental aggregation?

0 Answers  

How to generate or load values in to the target table based on a column value using informatica etl tool.

0 Answers   Informatica,

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 Answers  

source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

2 Answers   Wipro,

What is transformation?

0 Answers  

Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers   IBM,

what is mapping parameter?

2 Answers   Cap Gemini,

what is the difference between copy object import objects using repositery manager which one is best

1 Answers   TCS,

What does reusable transformation mean?

0 Answers  

I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,

For more Informatica Interview Questions Click Here
Categories