3,if our source containing 1 terabyte data so while loading
data into target what are the thing we keep in mind?
Answer Posted / bakshu shaik
one more thing we need to take into consideration, along with above suggestions:
If the target having an index, Loading time (huge amount of data) increases/performance hazard......so it's always better to drop the index before loading(Stored procedure transformation) and create again after loading completed...!
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain how to import oracle sequence into informatica?
How can we use mapping variables in informatica? Where do we use them?
What is lookup change?
What do you mean by filter transformation?
Describe data concatenation?
Explain transaction control transformation in informatica
my source is junk data how will u remove that junk data by using unix please any one replay me
How many transformations can be used in mapplets.
How do you load only null records into target? Explain through mapping flow.
What is repository manager?
what is INFORMATICA TESTING process
Why sorter is an active transformation?
Explain the use of aggregator cache file?
What is the need of an ETL tool?
How do you take back up of repository?