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
- 6315 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
How can we handle two sessions in informatica?
lookup transformation with screenshots
What are the differences between oltp and olap?
whats the logic to load the lower level of granularity of data to fact table.
Explain sessions and how many types of sessions are there?
tell me the rules and responsblites in our project(my project is development)
What are the new features of Power Center 5.0?
Explain target update override in informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How to implement security measures using repository manager?
Explain why we use partitioning the session in informatica?
Sequence generator, when you move from develoment to production how will you reset
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is data movement mode in Informatica and difference between them?
Briefly define a session task?
