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 to remove duplicates in transformer stage by using stage variables?one example?
Define APT_CONFIG in Datastage?
what is the unix script to run the job? Please mention commands which we use often?
how can we create rank using datastage?what is the meaning of rank?
1)Source file contains one record, I want 100 records in target file.
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..
How can you write parallel routines in datastage PX?
What is the difference between hashfile and sequential file?
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
With out using Funnel Stage, how to populate the data from different sources to single target
what are fact tables and dimension tables? give example assuming one table.