Describe the stages of extract / transform process, including what should happen at each stage and in what order?
Latest Answer: Generally this is going to be 2 stage process, some times 3 stage depends on the requirement.Most of the time its 2 stage process. In first phase is to extract data from different source systems for eg : Oracle, Flat Files, SAP etc. and load into Stage ...
What are some typical considerations during the data cleansing phase
Latest Answer: The ultimate goal of data cleansing is to improve the organization's confidence
in their data. First set the bar for what kind of quality you are trying to
obtain. I usually shoot for a 99% level of confidence in my data. List the types
of data ...
What are the different tools available for Data Extraction
Latest Answer: Instead of Extraction we can say Intigration tools ( ETLs) some of those areInformaticaDatastageSASMicrosoft SSISOracle Warehouse Builder ...
Why is it necessary to clean data before loading it into the Warehouse
Latest Answer: Warehouse data is used as source data for data analysis and reporting. The data is organized into groups and categories (aggregation) and then summarized upon those groups (dimensions). These groups are based upon exactness.
For example "house", ...
can anybody tell me that what are the processes used by cognos and Informatica for ETL Extraction, Scrubbing and Fusion. If you have any detailed report then please send me onmy mail ID...nm_105@yahoo.co.inthanks
what are the roles and responsibilities of an ETL developer/designer/team lead?
Latest Answer: The ETL developer's responsibility is to ensure that the goals of the business with regards to data management are met. The developer should be able to design and implement a plan for all types of data movement or modification requested ...
when can we use stored procedure transformations.
Latest Answer: Whenever you need value from SP, that time you have to use store pro. transformation. Or whenever you would like to preform some activity on the DB after loading the data or before loading data through ETL process. It can be done through Shell scripts ...
If i delete one record in master table, then the same record is also deleted in dependent table, for this which transformation can we use.
What is the first one executed in a session? Is it the Truncate Target Table option or the Post SQL? Explain
Latest Answer: Truncate table will be executed first.Trunc. table gets esecuted before the table starts loading and post SQL executes after the session is completed (table loaded) ...
why we implement sarrogate key in ETL Process?
Latest Answer: To generate sequence numberGenerally it starts with 0neBasically it is to differentiate the primary key ...
View page [1] 2 3 4 5 6 7 Next >>
Go Top
