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
- 7107 Views
- NTT Data, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Does an informatica transformation support only aggregate expressions?
Briefly define reusable transformation?
What are different types of transformations available in informatica?
Repository user profiles
What do think which one is the better joiner or look up?
What is lookup transformation?
explain about unit testing? in real time?
What is source qualifier transformation in informatica?
What is a repository manager?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Tell me about Propagate functions in informatica
What is rank transform?
COM components can be used in Informatica
Mention few power centre client applications with their basic purpose?
can we override a native sql query within informatica? How do we do it?
