There are two file are there .1st file contains 5 records and
2nd file contain 10 records in target they want 50 records.how
can achieve this

Answer Posted / datastageboss

The question seems to be incomplte , I am preassuming
that there will be duplicate records in both set of data
on a key say K1

use a join stage , the join type will be full outer join
and key will be K1 ( mentioned above)

At the output link we will receive 5*10 =50 records

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the errors,warnings in datastage

2157


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

1905


why do u need the IOS upgradation in a FC switch

1877


What is the difference between validated and compiled in the datastage?

707


How we can covert server job to a parallel job?

601






Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1755


what is use of SDR function?

4713


What is the command line function to import and export the ds jobs?

683


how to abort the job its matain duplicates?

2110


What steps should be taken to improve Datastage jobs?

644


How can one find bugs in job sequence?

792


describe the Steps to confiure a Qlogic switch

1944


What is the difference between account and directory options ?

628


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2710


What is the difference between hashfile and sequential file?

728