Subscribe To
Posts
All Comments
Popular Posts
-
Netezza dosen't have any isnumeric check function, so in order to find out whether the column has non-numeric, use the following logic n...
-
@echo off :: ----------------------------------------------------------------- :: DataStageExport.bat :: -----------------------------------...
-
The error and reject capturing is one of the best practices that I recommend to all developers, let me explain in a very simple way Rejec... -
If you have table like below GROUP_NAME GROUP_ID PASS_FAIL COUNT GROUP1 5 FAIL 382 GROUP...
-
In data warehousing, a conformed dimension is a dimension that has the same meaning to every fact table in the structure. Conformed dim... -
The open document functionality between 3 and 4 is exactly the same expect a change the default URL The default URL to the OpenDocument web...
-
Source :-dwh-ejtl.blogspot.com Q1) Tell me what exactly, what was your role? A1) I worked as ETL Developer. I was also involved in requireme...
-
Migrate Universe from one database to another · First backup the original universe in case if something go wrong · Launch ... -
Additive: Additive facts are facts that can be summed up through all of the dimensions in the fact table. A sales fact is a good example f... -
One of the regular viewer of this blog requested me to explain the important's of the ETL mapping document. What is ETL Mapping Document...
-
Netezza ISNUMERIC Data Check Logic
-
Datastage DSX Files Export Script
-
Datastage Error and reject record Handling simplified
-
How to do PIVOT in netezza SQL
-
Conformed Dimensions with example
-
SAP BO Open Document in 4.1
-
Informatica Job Interview Question & Answers
-
SAP BO Universe and Report Migration Part 1
-
Types of Measures in Fact Tables
-
What is ETL Mapping Document ?A Real Time Example
0 comments: