3,if our source containing 1 terabyte data so while loading
data into target what are the thing we keep in mind?

Answer Posted / upendra

large amount of data in source file.So we can devide partitions and commit level ur own wish,then connected to different target table, each one target table better for bulk load.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to configure mapping in informatica?

674


Enlist the various types of transformations.

556


How many ways a relational source definition can be updated and what are they?

577


What do you mean by channel change?

537


What is the status code in stored procedure transformation?

683






What is transformation?

657


What is deployment group?

682


How you prepared reports for OLAP?

1151


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1867


How is union transformation utilized?

567


How can we update a record in the target table without using update strategy?

653


How do you migrate data from one environment to another?

645


What is a sequence generator transformation?

575


What the difference is between a database, a data warehouse and a data mart?

593


Explain the different lookup methods used in informatica?

585