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
- 6221 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
Define Pmrep command?
Enlist the various types of transformations.
How to convert multiple rows to single row (multiple columns) in informatica
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What are active transformations.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is Cognos script editor?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What are the new features of informatica 9.x developer?
how to load dimension table and fact table. plz tell me the steps.
Which version configuration tool used in ur project?
How do you load first and last records into target table?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Mention a few design and development best practices for informatica?
