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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / abhinaw prakash
You can implement the same using SCD 1.
Please let me know if you have any doubt.
Is This Answer Correct ? | 0 Yes | 1 No |
Hi experts, can anyone tell how much we use plsql in real time
HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com
Did u used latest transformations of 8.6.0? for what?
I want load the data into target with out 1st and last record.
can we see default group,when we use router?if yes how?
HOW TO YOU LOAD TIME DIMENSION
how will compare two mappings in two different repository?
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
what are presession,postsession success and postsession failure commands ?
In real time scenario where can we use mapping parameters and variables?
What are the performance considerations when working with aggregator transformation?
What is the Rankindex in Ranktransformation?