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
- 7717 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 are the different layers in the information server architecture?
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
How do you remove duplicate values in datastage?
If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records
What is the purpose of interprocessor stage in server jobs?
What are the different types of lookups in datastage?
How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?
How to move data set from one server to other?what are the steps to follow to do this?
Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??
How to transfer file from one system to another system in UNIX?which command to be use?
How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?
Why we need datasets ratherthan sequential files?
Teradata 
