What is the use of the User defined Environment variables?
Latest Answer: User Defined Environment Variables are used to pass the parameters in job level,stage level and sequncer job level.Regards,Veeru. ...
Describe the stages of extract / transform process, including what should happen at each stage and in what order?
Latest Answer: In the extract process, we extract the data from the different sources like data files, flat files, etc.. into the stagging area or we can say input area for the further processing.Once get files in the input, data is applied for the processing by applying ...
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
Latest Answer: Cognos and Informatica are not same tool that does the same work.Informatica is a ETL tool. It extracts data from various sources (Oracle, db2,
Sybase, etc) transforms it and loads data into the warehouse.Cognos is a reporting tool.
It ...
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) ...
View page [1] 2 3 4 5 6 7 Next >>
Go Top
