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
- 6248 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
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How to load a Dimension ? and how to load a fact table?
What are the various types of transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are the popular informatica products?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
In informatics server which files are created during the session rums?
Explain constraint based loading in informatica
How to convert multiple rows to single row (multiple columns) in informatica
explain about unit testing? in real time?
What is the difference between router and filter?
Explain the mapping variable usage example in informatica
How can informatica be used for an organization?
What are multi-group transformations?
