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
- 6345 Views
- Motorola, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / aparna
once the session loads the data to target ,truncate the staging table .So everytime we load is complete ,staging table will be empty .
In POST-SQL (Target ) : truncate the staging table .
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
what is mapping optimization? wat are the techniques for tat
Differentiate between a repository server and a powerhouse?
explain about session partitions ?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
What are the ETL tools available in DWH?
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
How to eliminate 1st and last rows from the source and load the inbetween rows.
Teradata 
