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?
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 |
How can you access the remote source into your session?
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
What are the different types of repositories created using informatica?
What is aggregate awareness?
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
How to recover the standalone session?
How to load the data from a flat file into the target where the source flat file name changes daily?
 Code page compatibly –Where all changes are made to handle the scenario.
what is the flow?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is the need of building a data warehouse?