Interested to Buy Any Domain ? << Click Here >> for more details...
delete data from staging table as it loads to target table.here is the case
we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
- 2 Answers
- 6105 Views
- Motorola, I also Faced
- E-Mail Answers
Answer Posted / aparna
once the session loads the data to target ,truncate the staging table .So everytime we load is complete ,staging table will be empty .
In POST-SQL (Target ) : truncate the staging table .
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is union transformation in informatica?
What is meant by pre and post session shell command?
what is INFORMATICA TESTING process
How do you load only null records into target? Explain through mapping flow.
What is workflow manager?
What is rank index in rank transformation?
Explain incremental aggregation in informatica
Can we create two repositories on same database instance in oracle?
What are the different lookup cache(s)?
What are the components of the workflow manager?
Explain sql transformation in script mode examples in informatica
What is informatica worklet?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How would you join a node to the already existing domain?
