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
- 11317 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 |
In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?
What are different types of transformations available in informatica?
Explain the tuning lookup transformation - informatica
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
How does the session recovery work.
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
What is the maplet?
What are the static cache and dynamic cache in informatica?
Explain constraint based loading in informatica
What are the mapping parameters and mapping variables?
Teradata 
