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
- 7789 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 difference between account and directory options ?
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.
Explain ibm infosphere information server and highlight its main features?
What are the functionalities of link partitioner?
How to reverse the string using unix?
Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?
Difference between server jobs & parallel jobs?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.
1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project
Have you used Unstructured data?
I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?
Teradata 
