Interested to Buy Any Domain ? << Click Here >> for more details...
3,if our source containing 1 terabyte data so while loading
data into target what are the thing we keep in mind?
- 7 Answers
- 9947 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sudheer113
Along with the above suggestions......
Better to use partitioning (single or multiple thread) and and increase the commit level to 50 lacs. Better to load first flat file instead of loading into table.
then if u r db is oracle better to use sql loader to load data from file to table.If DB2 than use db2 loader.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Scheduling properties,whats the default (sequential)
Difference between Data and Index Caches?
What are the performance considerations when working with aggregator transformation?
Differentiate between a database and data warehouse?
How to configure mapping in informatica?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are the differences between oltp and olap?
difference between informatica 8.1.1 and 8.6
How do you load alternate records into different tables through mapping flow?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is status code in informatica?
Explain the features of connected and unconnected lookup.
How to extract sap data using informatica? What is abap? What are idocs?
What are the types of presistent cache in look up tr.
What is the Rank index port in Rank transformation?
