GeekInterview.com
  I am new, Sign me up!
 

ETL Interview Questions


ETL Interview Questions

Questions: 65
Comments: 241
 ETL Tags
 Showing Questions 1-10 of 65 Questions
[1] 2 3 4 5 6 7 Next >>
 Sponsored Links

 
 ETL Interview Questions
Sorting Options :  

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 ...
Read Answers (1) | Asked by : nm_105

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 ...
Read Answers (1) | Asked by : skuchina

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. 
View Question | Asked by : skuchina

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 >>

Ask A Question
Go Top
 Sponsored Links

 
Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Expert Members
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape