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
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
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is informatica powercenter repository?
What is the maplet?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What are batches?
What are the popular informatica products?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is substr in informatica?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is a filter transformation and why it is an active one?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are pre and post-session shell commands?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
how we can load rejected record's at run time?(not through bad files)
What are the types of presistent cache in look up tr.