3,if our source containing 1 terabyte data so while loading
data into target what are the thing we keep in mind?
Answer Posted / chinni
1tera data is huge amount of data so if we use normal load
type it takes so much of time....to overcome this better to
use bulk loading...and also taking the large commit
intervals we can get good performance....and one more
technique is external loading.....
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
is it possible to index the data in cache of lkp transformation ?
What are the different ways to implement parallel processing in informatica?
How you prepared reports for OLAP?
Reusable transformation and shortcut differences
Under which circumstances, informatica server creates reject files?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What does command task mean?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Explain in detail scd type 2 through mapping.
How can we update a record in the target table without using update strategy?
Explain constraint based loading in informatica
How we can use union transformation?
Describe expression transformation?
can u give example for factless fact table
What are the different types of transformation available in informatica.