Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 ?    28 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

What are the designer tools for creating tranformations?

1 Answers   Informatica,

how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,

What is the difference between view and materialised view?

4 Answers  

What are steps to follow Informatica migration from 7x to 8x? Pls Explain...

1 Answers   CTS, TCS,

What is A cache?

2 Answers  

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

4 Answers   IBM,

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 Answers  

in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify

3 Answers   Patni,

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 Answers  

what is filelist concept in informatica

4 Answers  

How to load the source table into flat file target(with columns) in informatica?

4 Answers   Accenture,

For more Informatica Interview Questions Click Here
Categories