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
- 6357 Views
- Motorola, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is an aggregator transformation?
What is the cumulative sum and moving sum?
Informatica settings are available in which file?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
While migrating the data from one environment to another environment how would you manage the connections?
How does a sorter cache works?
Target increases every day even though no new record was inserted
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Differentiate between joiner and lookup transformation?
What are the differences between joiner transformation and source qualifier transformation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is a passive transformation?
What are the informatica performance improvement tips
How to update a particular record in target with out running whole workflow?
