guys pls tell me where we use sequence jobs exactly in
realtime proj explain pls with example.
- 2 Answers
- 6563 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
What is size of a transaction and an array means in a datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
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 the components of ascential data stage?
What are transforms and what is the differenece between routines and transforms?
How many Key we can define in remove duplicate stage?
What is the different type of jobs in datastage?
What is the difference between odbc and drs stage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What are the different plug-ins stages used in your projects?
why do u need the IOS upgradation in a FC switch
what is the use of surogate key in datastage
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
How to read multiple files using a single datastage job if files have the same metadata?
what is the difference between == and eq in UNIX shell scripting?
