Answer Posted / sunil
)At DB level we can simply DROP the stagin table.
2)then Create Target table at DB level.
3) Directly LOAD the records into target table.
NOTE: It is recommended to use staging area
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the various types of transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Explain pmcmd command usage in informatica
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is the meaning of decode in informatica?
What is the benefit of partitioning a session?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Differentiate between sessions and batches?
What are the components of the workflow manager?
How can you generate reports in informatica?
Define filter transformation?
What is repository manager?
What do you understand by a term domain?
Have you worked with/created Parameter file
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
