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
Answers were Sorted based on User's Feedback
Answer / coolboy
Hi,
Here we will use joiner for better performance.We will join
the two sources making source table as master source.so
only 100 comparisons will be done.So it will be very faster.
Whereas in static and dynamic we have to look up on the
target which is very large 5m rows.So caching will take
more time.
| Is This Answer Correct ? | 28 Yes | 3 No |
Answer / arnab
Lookup with No cache will make it faster , personal opinion
though , there are other ways do it also , if you have a
common key between the source and the target and they are
on the same database , it would be easier and faster to do
a join in the source qualifier itself and let the database
handle the query rather than Informatica server
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / vijaykumar
Answer 7# is wrong because here we have only 1 source. It is
correct in case of 2 sources.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / jaspreet banga
Its better to use connected dynamic non-persistent lookup
transformation, to lookup into the traget and if record
exist , update it else insert the new using unconnected
lookup tranmsformation..
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ajay bhosal
Uncached lookup can give you good performance here but only when your target is properly indexed. Moreover, it's not a good idea to hit the database 100 times and scan huge data volume in the database.
Similar or better performance can be achieved by using Joiner with Sorted Input, but ensure that 100 rows are in master pipeline and the detail pipeline is sorted.
There is no question of using cached lookup.
Answer will be Joiner.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / srik
5m => 5 million recors.
1) Since target side records are very huge compared to
the source, caching is not preffred. so No caching.
2) Again with no caching we can accomplsh this in 2 ways
a) By Joiner
b) Unconnected lookup
but as unconnected lookup is not in answers is in the
option, Joiner is the answer
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / prakash
USE NOCACHE,IT WILL GIVE BETTER PERFORMANCE RATHER THAN
JOINER
| Is This Answer Correct ? | 1 Yes | 1 No |
What is the term PIPELINE in informatica ?
How to import oracle sequence into Informatica?
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence
How to create a non-reusable instance of reusable transformations?
what we require for D.modelling?
hi all, Can anyone please tell me the relationship between informatica and business objects
Differences between connected and unconnected lookup?
Explain the difference between mapping parameter and mapping variable?
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
How you count the number of records available at your source?