Interested to Buy Any Domain ? << Click Here >> for more details...
guys pls tell me where we use sequence jobs exactly in
realtime proj explain pls with example.
- 2 Answers
- 7784 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 is the function in Transformer stage can act as Rank Function in oracle
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
What is difference between join, merge and lookup stage?
Explain Quality stage?
what is usage of datastage with materialized views
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
what are the types of nodes
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?
Teradata 
