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
Explain target update override in informatica
How is union transformation utilized?
How to partition the Session?
How to load the data from a flat file into the target where the source flat file name changes daily?
Which transformation should we use to normalise the COBOL and relational sources?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is informatica metadata and where is it stored?
What is mapping debugger?
define galaxy repository in informatica
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Where is metadata stored?
Describe an informatica powercenter?
What is the benefit of session partitioning?
Different sorts of metadata that stores in the storage facility?
What is a pre-defined event and user-defined event?