Answer / ramya

use sparse lookup when reference database is huge i.e ratio
of input data and reference data is 1:100 or more

Answer / venugopal

When the reference data is more and source data is very
very less at that time we are using the Sparce lookup i.e
the ratio is 1:100

Answer / naresh

Sparce Lookup : if u use normal lookup it takes the entire
table into memory and perform lookup..coming to sparce
lookup it directly perform the lookup in database level.

one more difference is we can update the data into reference
tables.

Answer / prasad

whenever the reference data is very huge than the primary
data then it will be problem for usig lookup stage,b'se the
data stored in buffer in lookup stage.using sparse lookup we
can perform the lookup in database level not in the
buffer,so the performance can be automatically improved...

Answer / chenna

sparse lookup has more memory so that if reference table
contains huge amount of data perfer to use sparse lookup

Answer / ananda

Join: When volume of data is more than 10 million in both
source and reference link.

Sparse Lookup: When reference data is > 500 million and
source data is <10 million.

Answer / vin

If reference data is huge then we will go for join stage.
Then when we will use join and sparce is useful?

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

4 Answers   UHG,

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?

5 Answers   Gallega, TCS,

Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?

1 Answers   TCS,

wt is the diff b/w odbc and oracle stage

2 Answers   Accenture, HCL,

how can u connect the client system directly at any time?

1 Answers   IBM,

What are the different layers in the information server architecture?

0 Answers  

how many types of sorting the data in data stage?

1 Answers   BoA, IBM,

Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.

4 Answers   iGate, Thirdware,

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

0 Answers   Alpharithm Technologies,

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

9 Answers   IBM,

where the log files or tables can store in DS?

2 Answers   IBM,

Could anyone give brief explanation bout datastage admin

0 Answers