#DateForumTypeThreadPost
4705 Mar 2014 @ 04:54 PSTDatabaseReplymy 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 ...
4604 Mar 2014 @ 09:07 PSTToolsReplyTeradata Parallel Transporter - Session Character SetHi feinholz Thanks for your reply. Any further suggestion from you on my case ?   Thanking You Santanu
4503 Mar 2014 @ 05:25 PSTToolsReplyTeradata Parallel Transporter - Session Character SetHi 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...
4428 Feb 2014 @ 09:09 PSTToolsReplyTeradata Parallel Transporter - Session Character SetHi 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...
4327 Feb 2014 @ 08:57 PSTToolsReplyTeradata Parallel Transporter - Session Character SetHi 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...
4227 Feb 2014 @ 06:15 PSTToolsReplyTeradata Parallel Transporter - Session Character SetHi 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...
4126 Feb 2014 @ 08:07 PSTToolsReplyTeradata Parallel Transporter - Session Character SetHi 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...
4026 Feb 2014 @ 08:04 PSTToolsReplyTeradata Parallel Transporter - Session Character SetHi Folks,  Anyone, any update. I need help on this one. Thanking You Santanu
3926 Feb 2014 @ 05:54 PSTToolsTopicTeradata Parallel Transporter - Session Character SetHi 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...
3817 Feb 2014 @ 03:21 PSTToolsTopicParallel Load into Single Table - TPUMP / TPTHi 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...
3711 Feb 2014 @ 11:42 PSTToolsReplyTeradata Parallel Transporter - queriesHi 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....
3603 Feb 2014 @ 01:59 PSTToolsTopicTeradata Utility ScriptHi 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 ...
3503 Feb 2014 @ 12:17 PSTToolsTopicTeradata 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...
3403 Feb 2014 @ 12:16 PSTToolsTopicTeradata 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...
3327 Jan 2014 @ 02:52 PSTDatabaseReplyGenerate SurrogateKey with a huge tableHi 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...
3226 Jan 2014 @ 11:36 PSTDatabaseReplyConverions 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&...
3121 Jan 2014 @ 10:21 PSTDatabaseReplyWhich 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...
3011 Jan 2014 @ 01:47 PSTToolsReplyBTET/ANSI Transaction in TPT/FASTLOADHi 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...
2911 Jan 2014 @ 01:41 PSTDatabaseReplyissue in fast load with algorithmic compressionHi 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...
2810 Jan 2014 @ 04:50 PSTDatabaseTopicissue 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...
2708 Jan 2014 @ 02:04 PSTToolsReplyBTET/ANSI Transaction in TPT/FASTLOADThanks 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...
2607 Jan 2014 @ 03:50 PSTToolsTopicBTET/ANSI Transaction in TPT/FASTLOADHi 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...
2502 Jan 2014 @ 09:58 PSTDatabaseReplyOrder of partition columns in MLPPIThanks 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
2401 Jan 2014 @ 10:07 PSTToolsReplyWhen 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 ...
2301 Jan 2014 @ 09:13 PSTDatabaseReplyOrder of partition columns in MLPPIHi Anyone, any help or any response, please share.   Santanu

Pages