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
- 10385 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
scenario where i can use only concurrent execution of workflow.
Describe expression transformation?
What is the command used to run a batch?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is a snowflake schema?
What is Data Caches size?
how to create user defined function (udf) in informatica
How to do unit testing in informatica?
Reusable transformation and shortcut differences
How are indexes created after completing the load process?
How does a sorter cache works?
how we can load rejected record's at run time?(not through bad files)
hi real timers . iam waiting for ur reply regarding ETL TESTING
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
How to use procedural logic inside infromatica?
