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 |
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
What are the issues you have faced in your project? How did you overcome those issues?
What is the Difference between DSS & OLTP?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What do you understand by SOA of Informatica?
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
What are the main issues while working with flat files as source and as targets ?
Can a joiner be used in a mapplet.
What are the mapping parameters and mapping variables?
What is the exact difference b/w IN and EXIST in Oracle..?
What is deployemnt groups, Lables, query and dynamic deployment group.
How does the server recognize the source and target databases. Elaborate on this.