guys pls tell me where we use sequence jobs exactly in
realtime proj explain pls with example.
- 2 Answers
- 7128 Views
- TCS, I also Faced
- E-Mail Answers
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
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.
Difference between server jobs & parallel jobs?
Define project in datastage?
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?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What are orabulk and bcp stages?
What are sequencers?
What are the primary usages of datastage tool?
How can one find bugs in job sequence?
Differentiate between Join, Merge and Lookup stage?
EXPLAIN SCD
What are the steps needed to create a simple basic datastage job?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
sed,awk,head
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
