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
- 6143 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
Explain constraint based loading in informatica
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Explain transaction control transformation in informatica
complex mapping ur project u r invlve can u explain and give real time example give me ?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How many ways a relational source definition can be updated and what are they?
What are the different types of transformation available in informatica.
what is mean by complex business rule ?
How to call shell scripts from informatica?
Explain the different dimensions.
Explain the aggregator transformation?
What is event and what are the tasks related to it?
What is a joiner transformation?
What is the reusable transformation?
What are the conditions needed to improve the performance of informatica aggregator transformation?
