source file contains 100 records, i want 10 records in
target file how it possible in datastage
Answer Posted / chandu
while running prompt put 10 rows.
then the job terminates after 10rows in target
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
How do you generate sequence number in datastage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Why do you need stage variables?
CHANGE CAPTURE
Define data aggregation?
Why fact table is in normal form?
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)
How to implement complex jobs in data stage?
What are the difference types of stages?
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 ?
What is the difference between odbc and drs stage?
Enlist various types of routines in datastage.
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are the processing stages?