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?
Answer Posted / 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 |
Post New Answer View All Answers
What is data transformation manager process?
What are data-driven sessions?
What are the types of caches in lookup? Explain them.
What do you understand by SOA of Informatica?
How can we handle two sessions in informatica?
How to do the error handling of if ur source is flatfiles?
What is the Process to creating lookup transformation in informatica
How to use procedural logic inside infromatica?
What is decode in static cache?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Can informatica load heterogeneous targets from heterogeneous sources?
can u any challenge your project?
How does a rank transform differ from aggregator transform functions max and min?
What is substr in informatica?
What is a sequence generator transformation?