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
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
Can we create a Integration service without a Repository service and vice versa?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How to go to the older version for a mapping?
Is it possible to use a client with different version than that of its Informatica server?
have u done any performance tuning? how u ll do?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is rank transform?
What are different types of transformations available in informatica?
According to his methodology what all you need before you build a datawarehouse
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
How do you load only null records into target?
What is a dimensional model?
can anyone suggest best free Talend data integration training online
What are the different transaction levels available in transaction control transformation?