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
- 6218 Views
- Motorola, I also Faced
- E-Mail Answers
Answer Posted / ram
Hi,
for identification add a port like source_id in the stage table.
create 3 session instances to load data from 3 sources.
write pre sql in each session instance to delete the
records from stage table.
delete from <stage_table>
where id in (select id from target table)
and source_id=<identifiaction_value>;
please let me know the if you have any questions.
bhupalreddy200@gmail.com
thanks
ram
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How many input parameters can exist in an unconnected lookup?
What is meant by active and passive transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is a repository manager?
Please let me know how to make encryption and decryption with example?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is a sequence generator transformation?
How to differentiate between the active and passive transformations?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Different sorts of metadata that stores in the storage facility?
What is the difference between Active and Passive transformation?
Differentiate between router and filter transformation?
How do you handle two sessions in Informatica
How to join three sources using joiner?
