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 |
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?
Can you explain link buffering?
what is usage of datastage with materialized views
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?
How a source file is populated?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
if ename='subbu' while running job the job should be abort how come?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?