623 | 24 Feb 2014 @ 04:58 PST | Database | Reply | Date as Integer | Usually this is done in the ETL phase .... which is responsible for fetching new data and populating Core/EDW tables.
About where to implement, you can implement it in an SP or in the SQL ... |
622 | 24 Feb 2014 @ 03:44 PST | Database | Reply | Date as Integer | HTH!
DROP TABLE EDW_TAB;
DROP TABLE STG_TAB;
CREATE VOLATILE TABLE EDW_TAB
(
ID INT,
NAME VARCHAR(10),
ADDRESS VARCHAR(50),
START_DATE DATE,
END_DATE DATE
) ON COMMIT PRESERVE... |
621 | 24 Feb 2014 @ 03:31 PST | Database | Reply | Date as Integer | I will share some basic SQLs sometime today.
|
620 | 24 Feb 2014 @ 03:31 PST | Database | Reply | Date as Integer | Also, in case data is there but address value has changed, you need to UPDATE the previous row and set:
END_DATE = CURRENT_DATE;
And INSERT new row [with updated Address] as befor... |
619 | 24 Feb 2014 @ 03:29 PST | Database | Reply | Date as Integer | A simple way to cater for SCD Type 2 would be as follows:
Assume you have a table as below:
Table1
ID INT,
NAME VARCHAR(10),
ADDRESS VARCHAR(50)
And you wish to track ... |
618 | 24 Feb 2014 @ 02:50 PST | Data Modeling | Reply | Understanding on Data modeling concepts | Also note .... Logical DM is database independent, hence can be learned irrespective of which database is present underlying.
For Physical DM, yes you need to have a good understanding of ... |
617 | 24 Feb 2014 @ 02:43 PST | Data Modeling | Reply | Converting Rows to Columns | You can have a look at following links:
http://forums.teradata.com/forum/database/sql-to-transpose-row-to-column-any-level-nth-level-of-data
http://forums.teradata.com/forum/database/tran... |
616 | 24 Feb 2014 @ 02:33 PST | General | Reply | check session history | To have a correct track of SQLs executed, you need to have DBQL enabbled. It can be enabled for a particular user or for all users system-wide.
You can also ask your DBA to enable it for y... |
615 | 24 Feb 2014 @ 02:29 PST | Database | Reply | Table Stats | Collecting stats is a step-by-step process, and there is no 100% correct way of doing it. There can be a scenario which works best for you today .... but may not work the same way after some time [... |
614 | 24 Feb 2014 @ 02:25 PST | Database | Reply | Regular Expression On Teradata 14.0 | Great work in progress Satyaki .... you should really consider publishing an article on this. :)
Can you also add some performance stats on these?
|
613 | 23 Feb 2014 @ 07:41 PST | General | Reply | FYP ideas | Its a fantastic idea. You can work around Call Detail Records - CDRs. Search for it on the web .... relating to that you can work on different aspects of reporting as well.
But first you n... |
612 | 23 Feb 2014 @ 07:35 PST | General | Reply | FYP ideas | So briefly, first check if you can get some assistance from local Teradata office. In parallel, finalize the industry to work with. And also try to find some contacts in the industry and have a dis... |
611 | 23 Feb 2014 @ 07:33 PST | General | Reply | FYP ideas | For the contact .... am online here usually, so you can ask anything you want here.
|
610 | 23 Feb 2014 @ 07:27 PST | General | Reply | FYP ideas | For the model .... you can get some documentation but getting an actual model would not be possible. Its a product from Teradata .... and you cant get it for free .... and am sure you wont be going... |
609 | 23 Feb 2014 @ 07:25 PST | General | Reply | FYP ideas | Do you have a local Teradata office? And if yes, can you find some reference there .... may be via your university?
|
608 | 23 Feb 2014 @ 07:09 PST | General | Reply | FYP ideas | I would suggest you to get some sort of model from your teachers, and then you can change it your way.
Regarding industry selection, what interests you the most .... which industry do you ... |
607 | 22 Feb 2014 @ 10:28 PST | Database | Reply | Date as Integer | It would be better to store it as a date, but when you need to show it on a frontend, you can use CAST with FORMAT to specify the required format i.e. 'DDMMYYYY'.
HTH!
|
606 | 22 Feb 2014 @ 10:26 PST | Database | Reply | SQL help | You can invoke FastExport script, or you can read data and generate a file in your application.
SQL doesnt generate file, its the application above that does it after getting the data form... |
605 | 22 Feb 2014 @ 10:22 PST | General | Reply | error: The format or data contains a bad character | Can you share the values of the column: a13.FiscalWeekID
|
604 | 20 Feb 2014 @ 11:31 PST | Training | Reply | TERADATA | Topic moved to 'Training'.
|
603 | 20 Feb 2014 @ 10:18 PST | General | Reply | FYP ideas | 8-10 months is a good enough time.
You can work on a project comprising of some subject-area(s) of an industry .... and you can have some related reports done.
Have you given a th... |
602 | 20 Feb 2014 @ 10:15 PST | Database | Reply | Multiple values using case statement | And what output do you expect from following:
exec samplemac('0');
|
601 | 20 Feb 2014 @ 10:13 PST | Database | Reply | Date as Integer | What are the other columns in your table Test?
You need to have a join in an update based on same [but uniquely identifying] columns.
|
600 | 20 Feb 2014 @ 05:47 PST | Database | Reply | Sequence Generator | Most easiest way would be as follows:
CREATE TABLE tab1
(
Name VARCHAR(10)
);
INSERT tab1 VALUES ('a');
INSERT tab1 VALUES ('b');
INSERT tab1 VALUES ('c'... |
599 | 20 Feb 2014 @ 05:41 PST | Database | Reply | Multiple values using case statement | But how do you plan to relate 206 and 0? On what basis?
|