GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

ETL Interview Questions


ETL Interview Questions

Questions: 64
Comments: 235
 ETL Tags
 Showing Questions 11-20 of 64 Questions
<< Previous 1 [2] 3 4 5 6 7 Next >>
 Sponsored Links

 
 ETL Interview Questions
Sorting Options :  

Can any one let me know where can i find the list of ETL & reporting tolls available in the market. thanks in advance 
Latest Answer: SQL Server 2005 Integration Services for ETL - SSISSQL Server 2005 Reporting Services for reporting - SSRSBusiness Objects - Crystal Reports for reportingInformatica for ETL ...

Latest Answer: (sources)---------->Staging Area(Transformation)---->Target------>Interface-->ReportsData baseFlat filecobol fileXML file ...
Read Answers (1) | Asked by : sainath

Latest Answer: Global shortcuts are across multiple repositories,Local shortcuts are across multiple folders in the same repository. ...
Read Answers (1) | Asked by : Rohit Gupta

In What scenario ETL coding is preferred than Database level SQL, PL/SQL coding? What is the methodology and process followed for ETL testing in Data warehouse environment? Develop a mapping to extract the employee drawing maximum salary where deptno = department drawing... If LKP on target table is taken, can we update the rows without update strategy transformation? How you capture changes in data if the source system does not have option of storing date/time field... What is the Difference between
Read Answers (2) | Asked by : srihari

Latest Answer: I assume ETL coding means using ETL tools like Informatica.If the data is coming from completely different source systems as flat files, cobol files, RDBMS, XML, etc., it is better to use some intelligent ETL tools like informatica but if the  data ...

Latest Answer: Like ETL SPEC,they create a document containing the source table (Schema name) and a target table (another schema name) with the logic used in transforming source to target. We have to write database query with the logic contained in the document using ...
Read Answers (2) | Asked by : suma

Develop a mapping to extract the employee drawing maximum salary where deptno = department drawing maximum sum(salary) group by dept.sources are cobol files / flat files.
This is the recent question faced in ibm. 
Read Answers (4) | Asked by : naresh

Latest Answer: Update strategy transformation determines whether to insert, update, delete or reject a record for the target.  We can bypass update strategy transformation by creating a router to divide rows based on insert, update, etc and connecting ...

How you capture changes in data if the source system does not have option of storing date/time field in source table from where you need to extract the data?
The DW database can be Oracle or Teradata. The requirement here is to pull data from source system and ETL need to device a mechanism to identify the changes or new records. The source system can be a 
Read Answers (1) | Asked by : GeekNo1

Latest Answer: ODS (Operational Data Source) is the first point in the Datawarehouse. Its store the real time data of daily transactions as the first instance of Date.Staging Area, is the later part which comes after the ODS. Here the Data is cleansed and temporarily ...
Read Answers (3) | Asked by : nagireddy

View page << Previous 1 [2] 3 4 5 6 7 Next >>

Ask A Question
Go Top
 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
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape