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
- 7336 Views
- NTT Data, I also Faced
- E-Mail Answers
Answer Posted / harleen
The question needs to be corrected.I think there are 3 rows already in the target and only one row has to be inserted.
The same can be done by 2 ways
1)Update strategy (Update as Insert)
2)Dynamic lookup
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Where can we find the throughput option in informatica?
Briefly explain the aggregator transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
r u done any partitions in ur project?
server hot-ws270 is connect to Repository B. What does it mean?
Explain pushdown optimization $pushdownconfig parameter - informatica
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is the difference between router and filter?
How can a transformation be made reusable?
Which version configuration tool used in ur project?
What is union transformation?
What is the command used to run a batch?
expain about the tune parameters?
can anyone suggest best free Talend data integration training online
