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
- 6343 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 dynamic cache?
Describe data concatenation?
can you please explain me pre session and post session options?
What is joiner transformation in informatica?
What are the various types of transformation?
what is Active lock explain
What are ETL Tools?
What are the differences between source qualifier and joiner transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Tell me about MD5 functions in informatica
What is meant by incremental aggregation?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How do you convert single row from source into three rows into target?
What are the popular informatica products?
What is a snowflake schema?
