i have a job with 3 possibiliies
finish with ststus ok
abbort
warning
how do you handle these 3 in job sequence?
explain the situation where you have appiled scd in your project? chandu
No Answer is Posted For this Question
Be the First to Post Answer
project Steps,hits, Project level HArd things,Solved methods?
options available in sequence job to run,validate?
Which warehouse using in your datawarehouse
what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?
how to abort the job its matain duplicates?
LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?
How to add zero "0" before record in a field?
what is sparse lookup?
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??
What are some prerequisites for datastage?