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
- 4978 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 the flat file partition and where have to specify it
Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
What are the diffrences between joiner transformation and source qualifier transformation?
what we require for D.modelling?
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
what is inline view?
How would you join a node to the already existing domain?
Without using Lookup & Sequence Generator, How to generate Sequence?
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
What are the types of maping in Getting Started Wizard?
Plz..let me know differences between Informatica 7.1 and 8.1?
Teradata 
