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
- 7583 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 |
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
if i have a delimited file as source so how can we seperate this file into three diff targets?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
What is the need of an ETL tool?
what is the size of your data warehousing?
Where is the cache stored in informatica?
What are the main issues while working with flat files as source and as targets ?
What is a filter transformation?
What is joiner transformation in informatica?
How to partition the Session?
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how
Teradata 
