guys pls tell me where we use sequence jobs exactly in
realtime proj explain pls with example.
Answer Posted / 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 |
Post New Answer View All Answers
Define project in datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
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 is the flow of loading data into fact & dimensional tables?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
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.
how to abort the job its matain duplicates?
What is a datastage job?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What can we do with datastage director?
What is size of a transaction and an array means in a datastage?
Differentiate between odbc and drs stage?
How do you reject records in a transformer?
What are the types of containers in datastage?
What is the process of killing a job in datastage?