InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Explain The Process Of Extracting Data From Source Systems, Storing In Ods And How Data Modelling Is Done? |
|
Answer» There are VARIOUS ways of Extracting Data from Source Systems. For example , You can use a DATA step, an Import Process. It depends with your input data STYLES. What kind of File/database it is residing in. Storing ur data in an ODS can be DONE thru an ODS STMT/export stmt/FILE stmt, again which depends on the file & data FORMAT,You want your output to be in. There are various ways of Extracting Data from Source Systems. For example , You can use a DATA step, an Import Process. It depends with your input data styles. What kind of File/database it is residing in. Storing ur data in an ODS can be done thru an ODS stmt/export stmt/FILE stmt, again which depends on the file & data format,You want your output to be in. |
|