Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



If my source is having 30 million records, so obviously the cache could not be allocated with suffic..

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

If my source is having 30 million records, so obviously the cache could not be allocated with suffic..

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

Post New Answer

More Informatica Interview Questions

How can you access the remote source into your session?

1 Answers  


wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,


how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.

5 Answers   Keane India Ltd,


What are the different types of repositories created using informatica?

0 Answers  


What is aggregate awareness?

1 Answers  


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 ??

3 Answers   IBM,


How to recover the standalone session?

2 Answers  


How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers   Informatica,


&#61656; Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,


what is the flow?

1 Answers  


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

0 Answers   TCS,


What is the need of building a data warehouse?

2 Answers  


Categories