Interested to Buy Any Domain ? << Click Here >> for more details...
On a day, I load 10 rows in my target and on next day if I
get 10 more rows to be added to my target out of which 5 are
updated rows how can I send them to target? How can I insert
and update the record?
- 6 Answers
- 13185 Views
- I also Faced
- E-Mail Answers
Answer Posted / rohan
Here the requirement is to update the existing record and insert the new record. Its nothing but SCD1
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
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 open an older version of an object in the workspace?
What is the function of union transformation?
Explain transaction control transformation in informatica
How to partition the Session?
Difference between Target-based loading and constraint-based loading?
What is the fact table?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What are the new features of Power Center 5.0?
What are the differences between source qualifier and joiner transformation?
What is the difference between router and filter?
What are the differences between a connected lookup and unconnected lookup?
What is the function of look up transformation?
What are the guidelines to be followed while using union transformation?
