Toolbox for IT
Topics
Data Warehouse
Ask a Question
Answer Questions
Search
Please enter your question.
Popular last updated Thu February 7, 2013
Hi all,
Need all your inputs to resolve the following requirement..
col1 col2 col3
201301 n 1
201302 n 1
201303 p 2
201304 p 2
201305 n 3
201306 p 4
We have to generate the col3 based the changes in col2..if flag is changing add '1' to previous value..if no change in the flag then keep the value as previous.
Thanks in advance
TOAD, Teradata, SQL, Titles in Select Statements, SAS ODS Output
Question by
WPoling | 1 day ago in
Teradata
Hi, is there a way to create a title line or two using SQL in a select statement, like SAS ODS Output?
Thanks for any input!
WHP
Example:
TITLE1 "&SYSDAY";
TITLE2 "&SYSDATE";
TITLE3 "My Name";
TITLE4 "Data From autoy04y05y06a";
TITLE5 "Frequencies...
read more
The Cleavage in Cybernetics
Blog post By
Duke Ganote | 11 days ago
As you know from an earlier posting, I've been slowly, slowly meadering my way through the tome "Dark Hero of...
Magic MODEL: Secrets of the Faro -- Convergence
Blog post By
Duke Ganote | 10 days ago
Last time, I looked at the "faro shuffle" (also known as the "perfect shuffle" or "weave shuffle" to Alex Elmsley ...
Magic MODEL: The Holy Grail of Card Shuffling
Blog post By
Duke Ganote | 16 days ago
I've just finished reading the book "Fooling Houdini: Magicians, Mentalists, Math Geeks, and the Hidden Powers of...
Greek MODEL: Simple Sieve of Eratosthenes
Blog post By
Duke Ganote | 24 days ago
Back in the early fall of 2012, I was working with prime numbers -- for reasons I don't recall now. In an Oct...
Get Cutting-Edge Research
The latest Data Warehouse white papers, delivered to your inbox.
Data Warehouse
A data warehouse is a relational database that is designed for query and analysis rather than transaction processing. A data warehouse usually ...
More
Popular White Papers
- iPad in Business: Apps in Business
- The Do’s and Don'ts of ERP Implementations
- iPad in Business: iPad in Action
- ERP Winners & Losers
- IT Checklist for ERP Vendor Evaluation
More White Papers
Browse Data Warehouse Topics
Administration
Basic Data Warehouse
Business Strategy / Planning
Career
Data Warehouses/Marts
Extract, Transform, Load
Implementation
Packaged DW Suites