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
- 7341 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
What could be the possible resons of locks by user?
What is informatica etl tool?
What is a node in Informatica?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is resilience time?
What is the cumulative sum and moving sum?
Explain constraint based loading in informatica
What is the meaning of decode in informatica?
What are the different types of olap? Give an example?
On which transformations you created partitions in your project?
Which version configuration tool used in ur project?
What is the sequence generator transformation in informatica?
What are junk dimensions?
What does reusable transformation mean?
Can we change Dynamic to Static or Persistent cache? If so what happens?
