Interested to Buy Any Domain ? << Click Here >> for more details...
from Source 100 rows are coming, on target there are 5 m
rows which options is better to match data
1. Joiner
2 No cache
3. Static
4. Dynamic
- 21 Answers
- 39263 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / jaybrata
Unless you want to join in Database, the only option considering performance is - USE NO CACHE.
BUT, you have to have proper index defined on your target database table, this is crucial as otherwise there will be 100 full table scans on 5 million records.
Static Cache is the worst option as it will always cache 5 million records just to compare 100 records.
Dynamic cache is not an option assuming 100 source records do not contain duplicate.
Informatica side joining is also not good, better to join in DB side instead (To know why and to check the comparison between Infa side and DB side joins, check www.dwbiconcepts.com)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between informatica 7.0 and 8.0?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
scenario where i can use only concurrent execution of workflow.
What do think which one is the better joiner or look up?
how tokens will generate?
How we can create indexes after completing the loan process?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How to update source definition?
Explain the aggregator transformation?
Differentiate between sessions and batches?
Explain the etl program with few examples.
What is the command used to run a batch?
What is an expression transformation?
What are the tasks that source qualifier perform?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
