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
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 persistent lookup cache?
While migrating the data from one environment to another environment how would you manage the connections?
Clarify the aggregator change?
What is meant by lookup transformation? Explain the types of lookup transformation?
Which development components of informatica have the highest usage?
What are session parameters ? How do you set them?
In which transformation you cannot drag ports into it?
How you know when to use a static cache and dynamic cache in lookup transformation?
Define pmcmd command?
what is SDLC way of code development?
How do you load only null records into target? Explain through mapping flow.
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Explain sessions and how many types of sessions are there?