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
- 7056 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
Explain the mapping variable usage example in informatica
What are the tasks that can be performed using sq?
can anyone explain me about retail domain project in informatica?
r u done any partitions in ur project?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is exclusive and normal mode for repository services?
What are the features of complex mapping?
which one is better performance wise joiner or look up
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are the issues you have faced in your project? How did you overcome those issues?
How can you generate reports in informatica?
What is olap (on-line analytical processing?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are the components of workflow manager?
