1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / achoudhr

Answers were Sorted based on User's Feedback



from Source 100 rows are coming, on target there are 5 m rows which options is better to match dat..

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 ?    27 Yes 3 No

from Source 100 rows are coming, on target there are 5 m rows which options is better to match dat..

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

from Source 100 rows are coming, on target there are 5 m rows which options is better to match dat..

Answer / srinu

My understanding from ur ques--Target havining 5 rows
(Related to Sorce source rows),

Can u Explain (5 m rows Briefly)


srinu.srinuvas@gmail.com

Is This Answer Correct ?    3 Yes 1 No

from Source 100 rows are coming, on target there are 5 m rows which options is better to match dat..

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

from Source 100 rows are coming, on target there are 5 m rows which options is better to match dat..

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

from Source 100 rows are coming, on target there are 5 m rows which options is better to match dat..

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

from Source 100 rows are coming, on target there are 5 m rows which options is better to match dat..

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

from Source 100 rows are coming, on target there are 5 m rows which options is better to match dat..

Answer / achoudhr

I wanted to ask, why Static is better than other 3 options.

Is This Answer Correct ?    0 Yes 0 No

from Source 100 rows are coming, on target there are 5 m rows which options is better to match dat..

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

from Source 100 rows are coming, on target there are 5 m rows which options is better to match dat..

Answer / prakash

USE NOCACHE,IT WILL GIVE BETTER PERFORMANCE RATHER THAN
JOINER

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Informatica Interview Questions

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

In joiner, how to load Master table in Target?

2 Answers  

what is the size of ur database(like oracle)

2 Answers   HP,

How to load relational source into file target?

3 Answers   IBM,

What is the Difference between PowerPlay transformer and power play reports?

1 Answers  




What is DR strategy for Informatica project?

0 Answers  

Can informatica load heterogeneous targets from heterogeneous sources?

0 Answers  

Which is the best place to learn Informatica Powercenter Online Training?

1 Answers  

Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks

4 Answers  

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,

What is a data modeling?

2 Answers  

How will you check the bottle necks in informatica? From where do you start checking?

3 Answers   HCL,

For more Informatica Interview Questions Click Here
Categories