Sign Up Login


  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

What is a joiner transformation and why it is an active one?

779

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1830

What is exclusive and normal mode for repository services?

899

What are the differences between joiner transformation and source qualifier transformation?

891

What is the status code in stored procedure transformation?

899

permutations of mapplet

2259

Explian the Process of deployment groups in informatica

827

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

873

What is meant by incremental aggregation?

765

Describe expression transformation?

872

What is the session task and command task?

788

Explain the features of connected and unconnected lookup.

734

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6890

What are the modules in Power Center

1430

What is a dimensional model?

748