If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
- 2 Answers
- 6999 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gm
In This Case We have to do source partion. It means source
may be divided into sevral sources. DBA people will do.
After that create mapping for every source and make it
parralles session. and same target.
================================
Easy To Say: We have to do partion in source.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / vivek
I think before sending
data from the source if we
sort the data by sql
override i.e by adding a
"order by" clause in
default sql querry then
our problem wil be solved.
| Is This Answer Correct ? | 0 Yes | 12 No |
What is difference between stored procedure transformation and external procedure transformation?
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
what is the need of session partitioning... how it is useful in real time
what is surrogate id ?
What are the diffrences between joiner transformation and source qualifier transformation?
How you can differentiate between connected lookup and unconnected lookup?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
What are the different types of Type2 dimension maping?
How to import oracle sequence into Informatica?
Could you explain what is enterprise data warehouse?
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
How do you remove duplicate records in informatica?
Teradata 
