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
- 7805 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 |
Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.
I have 100 records how can I load at a time from the single time
Describe the architecture of datastage?
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know
how to handle null values using transformer stage?
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
What are the main features of datastage?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
How to move data set from one server to other?what are the steps to follow to do this?
what is a force compile
How can remove duplicates in a file using UNIX?
What is ds designer?
Teradata 
