| 57741 | 14 Jun 2016 @ 10:08 PDT | feinholz | Tools | Reply | Can TPT be used to load file with 10M records of 3500 attributes ??? | Please explain what you mean by "attributes"?
Will each field in the delimited file be loaded into a column of a table in a Teradata Database?
An example of a record from the file would... |
| 57740 | 14 Jun 2016 @ 09:01 PDT | smantry | Connectivity | Reply | Command line installation for ODBC Driver for Windows 15.00.00.00 | I could not find any documentation which can help me in deploying the ODBC Suite silently. Can anyone guide me to the right direction ?
|
| 57739 | 14 Jun 2016 @ 08:09 PDT | CarlosAL | Database | Reply | Is it an ordering - How do I generate a column that gives me the seq no of the select | Hi.
SQL SELECT does NOT guarantee (even in Oracle) any order of the rows returned if no ORDER BY clause is used.
The Oracle ROWID does not provide an order of insertion. It is related t... |
| 57738 | 14 Jun 2016 @ 07:02 PDT | mario_rozario | Tools | Reply | TPT Data Connector Error reading JSON | Has this issue been resolved?
I am still facign the same issue. Here is my code: -
DEFINE JOB LOAD_JSON_FROM_FILE
DESCRIPTION 'Load file using inserter operator'
(
/**... |
| 57737 | 14 Jun 2016 @ 07:01 PDT | celinexu | Database | Topic | Ask help regarding to TOP, Rank and Partition | Hi, I am new to Teradatabase and try to adapt my way into it. I am a data analyst not a developer.
Say I have a database as follow
Table name is TRS
PK
sku store price&n... |
| 57736 | 14 Jun 2016 @ 06:51 PDT | h.r.thejas@gmail.com | Tools | Topic | TDCH-TPT Interface | Hey Guys,
I was trying to export a large table from Teradata to HDFS as a textfile using TDCH-TPT Interface i was able t... |
| 57735 | 14 Jun 2016 @ 06:50 PDT | GTeradata | Jobs | Reply | software Training | Please share it to gaurav.malbari@gmail.com
|
| 57734 | 14 Jun 2016 @ 06:41 PDT | GTeradata | General | Reply | interview help | Hi Anand,
Please send it to gaurav.malbari@gmail.com
|
| 57733 | 14 Jun 2016 @ 06:07 PDT | sachins | Database | Reply | Degraded Query performance while performing insertion | Hi,
Please find below the DDLs of the source and target tables.
1) Source Tables(JEDI_CDW_DB.CALL_HIST and JEDI_AGR_DB.CDR_COST_HIST_PRE)
2) Target table - JEDI_AGR_DB.CALL_DAY_IMAGE_1
DDL of J... |
| 57732 | 14 Jun 2016 @ 04:59 PDT | Srividhya80_b | Database | Reply | Is it an ordering - How do I generate a column that gives me the seq no of the select | Thanks. I thought so. There was a rowid column that is no longer available. Can someone help me understand why? Is it to do with mpp architecture?
|
| 57731 | 14 Jun 2016 @ 04:46 PDT | yuvaevergreen | Database | Reply | Is it an ordering - How do I generate a column that gives me the seq no of the select | Rowid cannot be retrieved like Oracle afaik..
|
| 57730 | 14 Jun 2016 @ 04:39 PDT | yuvaevergreen | Database | Reply | Degraded Query performance while performing insertion | Can you post the ddls of the lookup and the source tables...
|
| 57729 | 14 Jun 2016 @ 04:35 PDT | chungtq | Database | Topic | Getting junk values for Latin column when using JDBC | Hi,
I have a table with some LATIN column as following:
CREATE SET TABLE Data_Produkty ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
DEFAULT MERGEBLOCKRATIO
(
... |
| 57728 | 14 Jun 2016 @ 04:32 PDT | yuvaevergreen | Database | Reply | Retrive data from table | Use the condition....where empid is not null or partyid is not null
|
| 57727 | 14 Jun 2016 @ 03:44 PDT | Chiraggorsia | Database | Topic | Spool in which volatile table lies. | Hi,
Is it possible to find the spool number in which volatile table lies?
Regards,
Chirag
|
| 57726 | 14 Jun 2016 @ 03:40 PDT | Chiraggorsia | Viewpoint | Reply | Negative Spool in Viewpoint | Hi Carlos,
Thanks for you answer.
But can you please update on what is Phantom / Orphan spool, Or do you have a link where I can read about it?
Regards,
Chirag
|
| 57725 | 14 Jun 2016 @ 02:48 PDT | Srividhya80_b | Database | Topic | Is it an ordering - How do I generate a column that gives me the seq no of the select |
Hi All
I have the following table
CREATE MULTISET TABLE HASH_V ,FALLBACK (
hashVal INTEGER
)
PRIMARY INDEX ( hashVal );
--data inserted in this order
insert into HASH_V val... |
| 57724 | 14 Jun 2016 @ 02:41 PDT | sachins | Database | Topic | Degraded Query performance while performing insertion | Hi Friends,
I have one query as below where we are performing an insertion in one empty table. The insertion statement is as below.The below insertion query is currently taking more than 20 hrs fo... |
| 57723 | 14 Jun 2016 @ 02:36 PDT | yuvaevergreen | General | Reply | to remove duplicates | Can you post some sample data
|
| 57722 | 14 Jun 2016 @ 02:30 PDT | Sram | Database | Topic | Retrive data from table | Hi team,
I have table A with four fields Empid,ename,salary,partyid.
i want to fetch data from table a where atleast of one of field Empid or Partyid should be not null value. if both fields are ... |
| 57721 | 14 Jun 2016 @ 02:24 PDT | yuvaevergreen | Database | Reply | Performance on having more than 30 Left outer join | volume of the lookup tables?...
|
| 57720 | 14 Jun 2016 @ 02:17 PDT | yuvaevergreen | Database | Reply | Convert text to a timestamp | CAST(CAST(TO_TIMESTAMP(OREPLACE('June 07,2016,HOUR 1','HOUR',''),'MONTH dd,yyyy,HH24') AS VARCHAR(19)) AS TIMESTAMP(0)) |
| 57719 | 13 Jun 2016 @ 11:04 PDT | nimish_123 | Database | Topic | Trigger log | There are DELETE/INSERT and UPDATE trigger defined on a table but when i am deleting or inserting record the expected action is not happening. How can i confirm the if trigger fired or not? Is ther... |
| 57718 | 13 Jun 2016 @ 07:56 PDT | MarkJBrayshaw | Viewpoint | Reply | Viewpoint Datalabs - 'non existant user' logon faiure | Thank you I'll follow that up with support
|
| 57717 | 13 Jun 2016 @ 06:02 PDT | Vishnujp | Database | Reply | Current date as column name in select query | The output looks like this
Current_date
16
|
