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 settings that you use to configure the joiner transformation?
How an expression transformation differs from aggregator transformation?
draw informatica architecture 8.6 ?
r u done any partitions in ur project?
What is enterprise data warehousing?
What is a dimensional model?
How to elaborate tracing level?
Write the unconnected lookup syntax and how to return more than one column.
How do you load only null records into target?
What is an aggregator transformation?
In informatica workflow manager, how many repositories can be created?
Define pmcmd command?
What are mapplets? How is it different from a Reusable Transformation?
Can we create two repositories on same database instance in oracle?
What are the different clients of powercenter?
