47 | 05 Mar 2014 @ 04:54 PST | Database | Reply | my confusion about LEFT JOIN | Hi
Optimizer will make the final decision. My understanding is probably optimizer is going for merge inner join. Try running explain and see the steps. You can try the below query if you want the ... |
46 | 04 Mar 2014 @ 09:07 PST | Tools | Reply | Teradata Parallel Transporter - Session Character Set | Hi feinholz
Thanks for your reply.
Any further suggestion from you on my case ?
Thanking You
Santanu
|
45 | 03 Mar 2014 @ 05:25 PST | Tools | Reply | Teradata Parallel Transporter - Session Character Set | Hi ratchetandclank
Are these attributes present some where in informatica ? Just wanted to know as I could not find such attributes in teradata. Any reference document suggestion for this wou... |
44 | 28 Feb 2014 @ 09:09 PST | Tools | Reply | Teradata Parallel Transporter - Session Character Set | Hi David
Thanks for reply.
Well, there is the problem. Even I thought defining the column as unicode and using UTF8 as session charset will work.
But the problem is we are supposed to lo... |
43 | 27 Feb 2014 @ 08:57 PST | Tools | Reply | Teradata Parallel Transporter - Session Character Set | Hi All,
Can anyone please tell me how to load Extended ASCII characters in UTF8 session charset to TD ?
Is there any way to insert '000A00BC'XC into teradata through any function or somet... |
42 | 27 Feb 2014 @ 06:15 PST | Tools | Reply | Teradata Parallel Transporter - Session Character Set | Hi Feinholz and others,
I have made a little progress on this. Now I know the problem is with some extended ASCII characters.
Such as, ASCII: 10 , 13, 188 etc.
I can find each individual charact... |
41 | 26 Feb 2014 @ 08:07 PST | Tools | Reply | Teradata Parallel Transporter - Session Character Set | Hi Feinholz
It is actually coming from oracle source. The thing is, people in my team tried to load that through informatica TPT API. There are 2 types of input data. Type-1 has chinease character... |
40 | 26 Feb 2014 @ 08:04 PST | Tools | Reply | Teradata Parallel Transporter - Session Character Set | Hi Folks,
Anyone, any update. I need help on this one.
Thanking You
Santanu
|
39 | 26 Feb 2014 @ 05:54 PST | Tools | Topic | Teradata Parallel Transporter - Session Character Set | Hi All
I am creating a TPT script to load some characters into table. I know if I set the session character set to UTF8 it will get loaded. But I am unable to set the session character set to UTF8... |
38 | 17 Feb 2014 @ 03:21 PST | Tools | Topic | Parallel Load into Single Table - TPUMP / TPT | Hi All
We have a requirement where we need to load one single table in parallel from different source tables.
Say, TableX needs to be loaded from TableA, TableB and TableC. They have different so... |
37 | 11 Feb 2014 @ 11:42 PST | Tools | Reply | Teradata Parallel Transporter - queries | Hi Feinholz
Thanks for your updates. They are really helpful.
Just for #3, I saw that kind of syntax somewhere on web. I guess that was only for shorter display purpose and I misinterpreted that.... |
36 | 03 Feb 2014 @ 01:59 PST | Tools | Topic | Teradata Utility Script | Hi
Someone told me, creating one teradata utility script within another is very handy.
For example, if I am writing a fastload script, I can put instructions to generate a fastexport script from ... |
35 | 03 Feb 2014 @ 12:17 PST | Tools | Topic | Teradata Parallel Transporter - queries |
Hi
I am using Teradata Parallel Transporter v13.10. I have few questions in this regard.
1. In MLOAD LAYOUT we can define .FILLER, which will not be sent to databas... |
34 | 03 Feb 2014 @ 12:16 PST | Tools | Topic | Teradata Parallel Transporter - queries |
Hi
I am using Teradata Parallel Transporter v13.10. I have few questions in this regard.
1. In MLOAD LAYOUT we can define .FILLER, which will not be sent to databas... |
33 | 27 Jan 2014 @ 02:52 PST | Database | Reply | Generate SurrogateKey with a huge table | Hi
In my knowledge, within teradata there are 3 ways to generate skey.
1. Indentity Column, 2. Hashing Algorithm and 3. Analytical Function
The 3rd option is more effective. We can use either RO... |
32 | 26 Jan 2014 @ 11:36 PST | Database | Reply | Converions of timestamp to FORMAT 'MM/DD/YYYYBHH:MI:SS' | Hi Nishant
Below worked for me.
SELECT
CAST(SUBSTRING (CAST ('01/23/2014 11:53:50.000000' AS VARCHAR(19)) ,1,19) AS TIMESTAMP(0) FORMAT 'MM/DD/YYYYBHH:MI:SS&... |
31 | 21 Jan 2014 @ 10:21 PST | Database | Reply | Which is efficient? | Hi Prateek
Looking at your query, my first response is, this query will give error. You are joining table b with table a on x3 column but you are not selecting x3 column in your sub-query. Instead... |
30 | 11 Jan 2014 @ 01:47 PST | Tools | Reply | BTET/ANSI Transaction in TPT/FASTLOAD | Hi
Thanks Feinholz and Saeed for your reply.
So I think any normal ODBC multistatement transaction (even through any BI tool) will follow the specific transaction rules of commit and rollback (AN... |
29 | 11 Jan 2014 @ 01:41 PST | Database | Reply | issue in fast load with algorithmic compression | Hi All,
Anyone, any insight.
Just to add, it is VARTEXT "," and this time I tried with bteq also. It worked. I am not getting the picture behind fast load and ALC column. Why such... |
28 | 10 Jan 2014 @ 04:50 PST | Database | Topic | issue in fast load with algorithmic compression |
Hi Guys,
I am doing fast load to an empty table which has one column with algorithmic compression (ALC) using TransUnicodeToUTF8. Below is my table structure.
CREAT... |
27 | 08 Jan 2014 @ 02:04 PST | Tools | Reply | BTET/ANSI Transaction in TPT/FASTLOAD | Thanks Saeed for your response.
So I guess if it is multi-statement insert/select in bteq with btet transaction mode, there will be rollback to last check point. However, the utilities will simply... |
26 | 07 Jan 2014 @ 03:50 PST | Tools | Topic | BTET/ANSI Transaction in TPT/FASTLOAD | Hi All,
I am having one problem.
I know BTET transaction is "all or none". If I submit a multistatement transaction and any one statemetn fails then entire transaction will roll back in... |
25 | 02 Jan 2014 @ 09:58 PST | Database | Reply | Order of partition columns in MLPPI | Thanks guys for your responses. I will consider them as my baseline and try to evaluate more. Probably I will post more questions if I need clarifications. :-)
Thanks
Santanu
|
24 | 01 Jan 2014 @ 10:07 PST | Tools | Reply | When are secondary indexes required? | Hi Guys,
I found something. I guess this NUSI is worthy for 1-AMP PI selection in a PPI table in some specific scenarios where optimizer decides to choose the NUSI index.
This time I created the ... |
23 | 01 Jan 2014 @ 09:13 PST | Database | Reply | Order of partition columns in MLPPI | Hi
Anyone, any help or any response, please share.
Santanu
|