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 the importance of the exception activity in datastage?
What are data elements?
Which commands are used to import and export the datastage jobs?
Describe the architecture of datastage?
What is data partitioning?
how to export or import the jobs in .ISX file
What are stage variables, derivations and constants?
How many areas for files does datastage have?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Where the datastage stored his repository?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What are the processing stages?
How to RD using transformer?
Give an idea of system variables.
Lookup constraints