723 | 26 Apr 2014 @ 10:10 PDT | Database | Reply | user creation | You need to put the following command in a macro/SP, havent tried that if there is any limitation for it in SP/Macro .... but command is fairly simple:
CREATE USER marks
... |
722 | 24 Apr 2014 @ 12:21 PDT | Database | Reply | Throttle Limits | TDWMThrottleStatistics contains some info .... but am not sure how you can link it with Profile.
|
721 | 24 Apr 2014 @ 12:14 PDT | General | Reply | Converting Oracle SQL*Loader scripts | I dont think there exists any tool/script .... even if it does am sure writing 40 Fastload/TPT scripts would be much faster as commpared to converting, testing, finding issues and then re-doing scr... |
720 | 21 Apr 2014 @ 11:23 PDT | Database | Reply | Need Help on Below Senario ? | Can you share sample input and output you desire?
|
719 | 21 Apr 2014 @ 10:43 PDT | Database | Reply | How to execute multiple macros in single statment. | You can have conditional logic [IF or CASE] either in SP or BTEQ script. For your scenario BTEQ script would be the workable option.
|
718 | 21 Apr 2014 @ 10:41 PDT | General | Reply | Case statement with multiple else | Please have a look at following link, it explains the CASE statement:
http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1145_111A/ch02.072.01.html
|
717 | 21 Apr 2014 @ 03:57 PDT | Teradata Applications | Reply | Table properties and utilities to load data | I dont think these attributes will have any significant impact on loading times. Bulk load through FastLoad or TPT is always going to give you far better performance as compared to other methods.
|
716 | 21 Apr 2014 @ 03:54 PDT | Third Party Software | Reply | Bi tool cannot read from different databases in teradata? | Its you choice to have views inn same or different DBs .... what i wrote above is that usually its 1 DB for tables .... and another seperate 1 for all the views.
Regarding BI limitation, y... |
715 | 20 Apr 2014 @ 06:22 PDT | UDA | Reply | Loading Unicode data from Oracle to teradata | You can verify your loaded data using CLI based connectivity i.e. BTEQ.
Also, about the setting that Qaisar has mentioned .... you need to go to ODBC -> Edit TD connection -> Change ... |
714 | 20 Apr 2014 @ 06:18 PDT | UDA | Reply | ETL CLOB from Oracle to Teradata | Please have a look at following link:
http://developer.teradata.com/tools/articles/large-object-loading-with-teradata-parallel-transporter
|
713 | 20 Apr 2014 @ 06:17 PDT | Analytics | Reply | Exit handling routine | Assuming you have all the error-tables in the Drp_Tables table .... you can export it as a text file and using an OS based script .... shell script .... you can send that list as an email.
|
712 | 20 Apr 2014 @ 12:26 PDT | Database | Reply | To compare data in different columns for different rows of records: | You can achieve that using self-join with a condition you mentioned above. To get the count you will be required to have a nested SELECT or derived table, and count the MBR_IDs in upper SELEC... |
711 | 20 Apr 2014 @ 12:06 PDT | General | Reply | Compare current row with previous row in TEradata | Also, PREV_PK_COLUMN_V is not an Informatica variable, so also state whats the source of this column.
|
710 | 20 Apr 2014 @ 12:04 PDT | General | Reply | When we need to collect stats on table | It is available in 14.10 version. For further details visit:
http://developer.teradata.com/blog/carrie/2013/12/easing-into-using-the-new-autostats-feature
|
709 | 19 Apr 2014 @ 11:59 PDT | General | Reply | Compare current row with previous row in TEradata | Is there any sorting being done in Informatica before this transformation?
|
708 | 19 Apr 2014 @ 11:58 PDT | General | Reply | BTEQ Script is failing | Indeed you need to have tables created and only then you can use them in SQL.
|
707 | 19 Apr 2014 @ 11:56 PDT | Database | Reply | Teradata Temporal Error | Following should work:
CREATE MULTISET TABLE Policy(
Policy_ID INTEGER,
Customer_ID INTEGER,
Policy_Type CHAR(2) NOT NULL,
Policy_Details CHAR(40),
... |
706 | 19 Apr 2014 @ 11:07 PDT | Database | Reply | Regarding date format | Dear, your hiredate is of year 2013 and current_date would definitely be of year 2014.
|
705 | 19 Apr 2014 @ 10:59 PDT | Database | Reply | Primary Index on VARCHAR column | Integer literals take less space as compared to charater literals.
For example, INT takes 4 bytes and CHAR(10) would take 10 bytes .... which effectively means more data to store, retrieve... |
704 | 19 Apr 2014 @ 12:19 PDT | Database | Reply | Skew Factor | PI is selected to give you bettter distribution and more importantly less or no re-distribution while using table. As its a stage table, you need to check transformation rules to know which colymns... |
703 | 19 Apr 2014 @ 12:14 PDT | General | Reply | How to copy a file from host to Teradata Express for VMware | Using VM Ware -> Manage -> Virtual Machine Settings -> Options -> Shared Folders .... you can have a folder shared between host & guest OS.
|
702 | 18 Apr 2014 @ 11:26 PDT | General | Reply | No Spool space error | Skewfactor can also have a larger values if the data-set is small. How many AMPs you have on the system? And can you execute and share result of bellow SQL:
SELECT col1, col2, col3, COUN... |
701 | 18 Apr 2014 @ 11:21 PDT | Database | Reply | Teradata Temporal Error | What is your TD Version?
|
700 | 18 Apr 2014 @ 11:20 PDT | Database | Reply | Scemantic Layer in Teradata Data Warehouse | The idea of DWH, usually is to contain as detailed data as possible, so you can answer any future reports using the same detailed data. Hence we say DWH models actual business and it is as per the ... |
699 | 18 Apr 2014 @ 11:12 PDT | Database | Reply | One record dropped on import function-can't figure out why | Can you please clarify 'import process'? Are you talking about SQL Assistant import?
Is it the file that youu are importing? Does the file have empty-line at the end?
|