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
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
which one is better performance wise joiner or look up
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is native users?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Target increases every day even though no new record was inserted
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
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
What is the difference between Active and Passive transformation?
Differentiate between a database and data warehouse?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Is it possible to revert a global repository to local one and why?
Differentiate between sessions and batches?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?