Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / srinivas
I will add some points to first answer
Source system send the raw data what ever data they have simply they will send to us.
In staging we do the cleansing, remove-duplicate and null handling process and load the data into staging tables.
Then we applying business logic's and loading into dim and fact tables.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
how to write server Routine coding?
What is the difference between operational data stage (ods) and data warehouse?
I have a few records just I want to store data in to targets cycling way how?
What is the different type of jobs in datastage?
What are stage variables and constants?
Difference between data warehousing and olap?
How to implement complex jobs in data stage?
What is use Array size in datastage
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are the various kinds of the hash file?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is merge stage?
Enlist various types of routines in datastage.
client know skid info?
