CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN
SERVER JOBS?
Answers were Sorted based on User's Feedback
Answer / nish
Yes,
For jobs that are less resource intensive create a server job.
Create the parallel job as usual
Create a sequencer to combine both jobs or configure a shared container in one of the jobs and re -use them
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kiran
Yes you can, as long as your client is OK with it. We
design jobs to finish certain tasks in ETL. If your task
has less data and more complex tranformations then use
server jobs and vice versa.
| Is This Answer Correct ? | 4 Yes | 4 No |
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
What is Cleanup Resources and when do you use it?
What is the difference between an operational datastage and a data warehouse?
can any one tell me how to install datastage 8.1 in windows xp with wizard
Define Merge?
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
How to perform incremental load in datastage?
Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.
my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?
Difference between the Sequence and Sequencer in DS?
source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?
1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?