Interested to Buy Any Domain ? << Click Here >> for more details...
How to fasten loading of 100 million distinct records in
informatica?
(Initially they are loaded into target without using any
transformation, taking 2 hours)
- 3 Answers
- 11123 Views
- Atriax, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / dev
Have index on the sources and make sure indexes are dropped in target(any ways these are distinct records) before load and opt for bulk loading. Once load is done you can create thee indexes again and maybe analyze the table also.
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / nitin tomer
1) Load Data using Bulk Load for that we have to drop index from the target table, but after loading the data to create the index will also take good amount of time
2) Create a sequence 1 to 100 million using sequence generator and create the pass-through partition to load data, let say 10 partition we can create from 1 to 100000 like that.
Partitioning will definitely give huge performance improvement.
| Is This Answer Correct ? | 0 Yes | 0 No |
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
Explain the difference between mapping parameter and mapping variable?
How can you generate reports in informatica?
Difference between Target-based loading and constraint-based loading?
 Informatica Checkpoints
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
What is the difference between source qualifier transformations source filter to filter transformation?
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
My source table having some records ,i want load 1st record and last record into one target?
Teradata 
