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 usage analysis in datastage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are the different types of lookups in datastage?
how many rows sorted in sort stage by default in server jobs
What are stage variables, derivations and constants?
Can you explain engine tier in information server?
How you Implemented SCD Type 1 & Type 2 in your project?
options available in sequence job to run,validate?
What are iconv and oconv?
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)
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Explain ibm infosphere information server and highlight its main features?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Define Routines and their types?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
