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
- 7921 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 |
can a fact table contains textual information
6 Answers HCL, HCL BSERV, IBM,
What is the importance of the exception activity in datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
what is the use of DSattchJob?DetachJob? where can we find it?
What are sequencers?
How did you reconcile source with target?
Differentiate between data file and descriptor file?
Can you explain players in datastage?
Notification Activity
How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?
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
I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
Teradata 
