guys pls tell me where we use sequence jobs exactly in
realtime proj explain pls with example.
Answer Posted / 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 |
Post New Answer View All Answers
What can we do with datastage director?
How will you move hashed file from one location to another location?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Define Data Stage?
What is the difference between datastage and datastage tx?
What are the differences between datastage and informatica?
how many rows sorted in sort stage by default in server jobs
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Where do you see different stages in the designer?
Define APT_CONFIG in Datastage?
What are stage variables, derivations and constants?
Define repository tables in datastage?
Notification Activity
Can you explain tagbatch restructure operator?