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?
- 2 Answers
- 7685 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are the different versions of informatica?
Design a mapping to load a target table with the following values from the above source?
differences between service based and product based?
What is the procedure for creating independent data marts from informatica 7.1?
Partition, what happens if the specified key range is shorter and longer
what is INFORMATICA TESTING process
What is pmcmd command?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Explain direct and indirect flat file loading (source file type) - informatica
What is native users?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How can you validate all mappings in the repository simultaneously?
What is substr in informatica?
