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
- 7624 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
How to eliminate duplicates from flat file..what is the procedure
which transformation uses cache?
hi all, Can anyone please tell me the relationship between informatica and business objects
Write the unconnected lookup syntax?
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
can you use flat file for lookup table?why?
How to update or delete the rows in a target, which do not have key fields?
What is standalone command task?
What are the differences between oltp and olap?
How to create a non-reusable instance of reusable transformations?
Teradata 
