How do y read Sequential file from job control?
Answers were Sorted based on User's Feedback
Answer / zafar
You can read sequential from a batch job. In the batch job
-->job control use functions
Open seq #path name#-- this will open the sequential file
Read seq..
check the syntax for these in hlp menu
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / kiran
when ever u want to run more than one job with single task
then u have to select batch processing.and batch processing
select with help of job control.
Is This Answer Correct ? | 4 Yes | 3 No |
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How many input links can you give to a Transformer stage?
explain unit testing,systemtesting,integrated testing
in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
1)How to Duplicate Records Delete in Sequential file?
what is 'reconsideration error' and how can i respond to this error and how to debug this
can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com
Describe routines in datastage? Enlist various types of routines.
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
How do you register plug-ins?