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
what are fact tables and dimension tables? give example assuming one table.
Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?
Why we need datasets ratherthan sequential files?
How do you get log info into a file?
What is the importance of the exception activity in datastage?
how can or from where we can get reference data in scd type2 implementation?
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?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
What is orabulk stage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?