Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 7340 Views
- NTT Data, I also Faced
- E-Mail Answers
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
Enlist some properties of sessions.
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain in detail scd type 2 through mapping.
How many dimensions are there in informatica?
What is aggregate cache in aggregator transformation?
What is the use of source qualifier?
write a query to retrieve the latest records from the table sorted by version(scd)
what is mean by complex business rule ?
What is meant by lookup transformation?
What is the function of union transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
can we override a native sql query within informatica? How do we do it?
What is an expression transformation?
What is workflow manager?
Can we create a Integration service without a Repository service and vice versa?
