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 / rakesh

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1262

What do you understand by SOA of Informatica?

981

what is song in infrmatica...?

2230

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1773

How to do unit testing in informatica?

1167

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1104

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2123

What are the different options available for update strategy?

1000

What is the benefit of partitioning a session?

1175

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1076

Write the unconnected lookup syntax?

1081

How does the aggregator transformation handle null values?

1147

Is stop and abort are same in informatica?

995

What is flashback table ? Advance thanks

1930

Differentiate between reusable transformation and mapplet.

1086