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 |
Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises
can explain wt is the pool for file.
HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com
How complex jobs are implemented in datstage to improve performance?
how to transfer file from one system to another system in unix? which cmd to be use?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What is orabulk stage?
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
What are routines in datastage?
Demonstrate experience in maintaining quality process standards?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Is possible to create skid in dim,fact tables?