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


Please Help Members By Posting Answers For Below Questions

What is the use of source qualifier?

670


What are the differences between a connected lookup and unconnected lookup?

646


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

636


What is the difference between a repository server and a powerhouse?

805


Explain the pipeline partition with real time example?

651






Under what condition selecting sorted input in aggregator may fail the session?

661


How can we store previous session logs?

565


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1966


Explain the features of connected and unconnected lookup.

544


What is a joiner transformation and why it is an active one?

578


Write the advantages of partitioning a session?

743


What is meant by query override?

633


What is mapplet in informatica?

592


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1618


How will the document be delivered to me?

614