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
what is 'reconsideration error' and how can i respond to this error and how to debug this
Is the value of staging variable stored temporarily or permanently?
What is process model?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
I have a few records just I want to store data in to targets cycling way how?
If you want to use the same piece of code in different jobs, how will you achieve it?
what is repositery?
What is the command line function to import and export the ds jobs?
How can we improve performance of data stage jobs?
What is the purpose of interprocessor stage in server jobs?
What are the processing stages?
What is the difference between datastage and datastage tx?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are the types of containers in datastage?
How many types of hash files are there?