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
- 7190 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 are active transformations.
How would you join a node to the already existing domain?
what is SDLC way of code development?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is DR strategy for Informatica project?
Explain direct and indirect flat file loading (source file type) - informatica
What do you mean incremental aggregation?
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??
How can we update a record in the target table without using update strategy?
How is union transformation utilized?
What are the differences between joiner transformation and source qualifier transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
What are the new features of informatica 9.x in developer level?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is persistent lookup cache?
