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 is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Where the datastage stored his repository?
How and where you used hash file?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Can you explain repository tables in datastage?
What is the differentiate between data file and descriptor file?
In Datastage, how you can fix the truncated data error?
What are the job parameters?
AGGREGATOR default datatype
How to Remove Duplicate using SQL?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Is the value of staging variable stored temporarily or permanently?
What are the various kinds of containers available in datastage?
On which interface you will be working as a developer?
how to export or import the jobs in .ISX file