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
- 6241 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
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How to go to the older version for a mapping?
Could you explain what is enterprise data warehouse?
which one is better performance wise joiner or look up
Which development components of informatica have the highest usage?
what is informatica metadata?
How to load the data from people soft hrm to people soft erm using informatica?
How to do unit testing in informatica?
What is deployment group?
Difference between Target-based loading and constraint-based loading?
tell me 5 session failure in real time how can you solve that in your project?
Mention some types of transformation?
What is the difference between informatics 7x and 8x and what is latest version?
What does command task mean?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
