guys pls tell me where we use sequence jobs exactly in
realtime proj explain pls with example.
- 2 Answers
- 7126 Views
- TCS, I also Faced
- E-Mail Answers
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 |
What all are the different way to run a job?
What is a merge?
How rejected rows are managed in datastage?
I have a few records just I want to store each records tow times in target how?
What is Cleanup Resources and when do you use it?
explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT
Difference between data warehousing and olap?
How we can convert rows to columns in datastage?
How to RD using transformer?
when we will use connected Lookup & Unconnected Lookup
how to call routines in stages?
How to convert alpha Numeric values to alpha using functions?
Teradata 
