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
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls
What is the use of surrogate key stage?
Describe routines in datastage? Enlist various types of routines.
Why we use surrogate key?
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.
difference between function and procedure...
How do u convert the columns to rows in datastage?
Where do the datastage jobs get stored?
In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.
how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project
hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(