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 |
Difference between JOIN,LOOKUP,MERGE?
What are the different kinds of views available in a datastage director?
how can u handle null values in transformer stage.
Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C
can a fact table contains textual information
6 Answers HCL, HCL BSERV, IBM,
I have 100 records how can I load at a time from the single time
in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
On which interface you will be working as a developer?
How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?
what is flow of project?