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
- 5 Answers
- 9968 Views
- IBM, I also Faced
- E-Mail Answers
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
What are the features of datastage flow designer?
Can you explain how could anyone drop the index before loading the data in target in datastage?
options available in sequence job to run,validate?
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...
What are orabulk and bcp stages?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
How complex jobs are implemented in datstage to improve performance?
describe the Steps to confiure a Qlogic switch
Differentiate between operational datastage (ods) and data warehouse?
Can you define merge?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What are transforms and what is the differenece between routines and transforms?
Differentiate between datastage and datastage tx?
What is quality stage?
What are the main features of datastage?
