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


Please Help Members By Posting Answers For Below Questions

How to differentiate between the active and passive transformations?

710


How do you manage the Parameter files while migrating your data from one environment to another environment?

653


What are the different types of olap? Give an example?

646


How do you set a varible in incremental aggregation

1537


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1825






What are Dimensional table?

691


How will the document be delivered to me?

706


What is union transformation in informatica?

802


What is the benefit of session partitioning?

700


How do you update the records with or without using update strategy?

756


What is informatica powercenter repository?

813


write a query to retrieve the latest records from the table sorted by version(scd)

721


What is meant by pre and post session shell command?

737


What are the designer tools for creating transformations?

774


Why filter transformation is an active one?

669