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
- 6253 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
lookup transformation with screenshots
Why is sorter an active transformation?
Where is metadata stored?
What are the types of caches in lookup?
Enlist some properties of sessions.
Plz can any one say me how to get the informatica certification materials and dumps
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Clarify the aggregator change?
What could be the possible resons of locks by user?
What are the steps involved in the migration from older version to newer version of Informatica Server?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
can anyone explain me about retail domain project in informatica?
Make a note of the quantity vaults made in informatica?
What is sequence generator transformation in informatica?
