Interested to Buy Any Domain ? << Click Here >> for more details...
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
Can we override a native sql query within informatica?
Parameter and variable differences
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is Index Caches size?
What is the commit type if you have a transaction control transformation in the mapping?
How can we improve session performance in aggregator transformation?
How to load last n records of file into target table - informatica
How does a rank transform differ from aggregator transform functions max and min?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How we can create indexes after completing the load process?
Design a mapping to load a target table with the following values from the above source?
Why do you use Mapping Parameter and mapping variable?
What is a grid in Informatica?
What are multi-group transformations?
What does reusable transformation mean?
