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...
-
If you have table like below GROUP_NAME GROUP_ID PASS_FAIL COUNT GROUP1 5 FAIL 382 GROUP...
-
@echo off :: ----------------------------------------------------------------- :: DataStageExport.bat :: -----------------------------------...
-
Netezza has 3 internal planner • Fact Relationship Planner (factrel_planner) • Snowflake Planner • Star Planner In the course of a query pla...
-
What is Big Data? Big data is data that exceeds the processing capacity of traditional database systems. The data is too big, moves too fast...
-
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...
-
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... -
I am sure most of you heard about market buzz words nosql,newsql... and it often make our DW developers to get confused on this new terms.Mo... -
In data warehousing, a conformed dimension is a dimension that has the same meaning to every fact table in the structure. Conformed dim... -
This note assumes some familiarity with the DataStage transformation engine. DataStage is normally used to process multiple input files and/...
-
Netezza ISNUMERIC Data Check Logic
-
How to do PIVOT in netezza SQL
-
Datastage DSX Files Export Script
-
Netezza Optimizer Parameters
-
Big Data and Hadoop Questions and Answers
-
Informatica Job Interview Question & Answers
-
What is ETL Mapping Document ?A Real Time Example
-
NOSQL 101
-
Conformed Dimensions with example
-
Data Generation Using DataStage
0 comments: