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
- 9861 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
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How union transformation is used?
How to create Target definition for flat files?
What is a node in Informatica?
How you prepared reports for OLAP?
What is olap (on-line analytical processing?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Explain lookup transformation is active in informatica
What are the differences between joiner transformation and source qualifier transformation?
Explain the types of transformations?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is informatica? Why do we need it?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
