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 / 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 |
Post New Answer View All Answers
What is lookup change?
During the running session, output files are created by informatica server. Enlist few of them.
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is rank index in rank transformation?
What is the status code in stored procedure transformation?
What are the features of complex mapping?
What is meant by a domain?
How to update or delete the rows in a target, which do not have key fields?
How can we create index after completion of load process?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Separate from a database, an information bazaar, and an information stockroom?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Can we create a Integration service without a Repository service and vice versa?