Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11431 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 types of jobs we have in datastage?
What are stage variables, derivations and constants?
Which algorithm you used for your hashfile?
What is the purpose of pivot stage and types of containers in datastage
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Can you highlight the main features of ibm infosphere information server?
Define repository tables in datastage?
Can you filter data in hashed file?
What are the job parameters?
How to perform incremental load in datastage?
What are the types of containers?
Define APT_CONFIG in Datastage?
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)
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
