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 ...
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 ...
Latest Answer: Global shortcuts are across multiple repositories,Local shortcuts are across multiple folders in the same repository. ...
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
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 ...
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.
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
View page << Previous 1 [2] 3 4 5 6 7 Next >>
Go Top
