guys pls tell me where we use sequence jobs exactly in
realtime proj explain pls with example.
Answers were Sorted based on User's Feedback
Answer / pavan kumar
Automated the parallel jobs we can use Sequencer in
DATASTAGE
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / srinivas
If you run multiple jobs with single command than we will the sequencers.
For example in real time data will load like below
Source--->Staging---->dimensions---->fact
If we wish to load the data sequncial manner first we will create staging jobs after that dimensions and last fact.
To process these will create sequencers and will trigger based on dependency.
Is This Answer Correct ? | 0 Yes | 0 No |
how to find diff between 2 dates without using Icon... funtions?
how can u connect the client system directly at any time?
what are the errors,warnings in datastage
what is the Difference Between Datastage Server Edition and Parallel Edition?
how CAN we remove duplicates in dataset?
wt is the diff b/w odbc and oracle stage
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What are the different plug-ins stages used in your projects?
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel
how to call routines in stages?
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.