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
- 6316 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
Repository user profiles
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What are the steps involved in the migration from older version to newer version of Informatica Server?
In development project what is the process to follow for an etl developer from day1
Explain in detail about scd type 1 through mapping.
Is it possible to use a client with different version than that of its Informatica server?
What is informatica powercenter repository?
what is the hint? how to use it to reduce the query processing in program?
what is index?how it can work in informatica
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?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What are the settings that you use to configure the joiner transformation?
Which version configuration tool used in ur project?
Explain how many types of dimensions are available in informatica?
Why union transformation is an active transformation?
