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 components of the workflow manager?

0 Answers  

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

Write the advantages of partitioning a session?

0 Answers  

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,

why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,

How do you handle two sessions in Informatica

0 Answers   Informatica,

How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

0 Answers   IBM,

What is the role of informatica in project ?Like i showed financial projects?

1 Answers   Amdocs,

My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

3 Answers   Cap Gemini,

i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,

For more Informatica Interview Questions Click Here
Categories