#DateForumTypeThreadPost
3513 Mar 2014 @ 09:38 PDTAnalyticsReplyWhy FastLoad Does not support NUSI ? i ahave 1 source file (diff date formats' (2014/02/28)(20140228)'), using fast load- 1 target table , is it possible to load ?.     thanks ratnam
3428 Feb 2014 @ 10:09 PSTAnalyticsReplyWhy FastLoad Does not support NUSI ?Hi all,   i want to load data from file to TD_TBL through Fastload, file is having date format some records like (2014/02/28)(20140228) the file having 1 millian records two dif dare forma...
3323 Feb 2014 @ 11:04 PSTData ModelingReplyConverting Rows to ColumnsHi all, i have a table data lik. id,loc1,loc2,loc3 101,hyd,mum,chennai --------------------------- but i want display like id,loc 101,hyd 101,mum 101,chennai how to get ?
3223 Jan 2014 @ 03:13 PSTDatabaseReplyCount and Sum by MonthHi raja,   like that but  i want retrive data result set is like  id,jan_Amount,Feb_amount.....etc
3123 Jan 2014 @ 02:02 PSTDatabaseReplysum of amout for the date falling in the respective month i.e months wise sum amount is requiredhi all,   i have a transaction table columns like  T_ID,T_DATE,T_AMOUNT .   Q : i need amount from date wise,and t_amount wise like bellow .  SEL...
3023 Jan 2014 @ 02:01 PSTDatabaseReplyCount and Sum by Monthhi all,   i have a transaction table columns like  T_ID,T_DATE,T_AMOUNT .   Q : i need amount from date wise,and t_amount wise like bellow .  SELECT T_ID,JAN_T_AMOUNT,FEB_...
2908 Jan 2014 @ 02:32 PSTAnalyticsReplyCall a macro from a stored procedure?hi raja,   we are developed some bteq script like error handling based upon status table we get the query table to target table loading data can loading .   Thanks Ratnam  &nb...
2808 Jan 2014 @ 01:23 PSTDatabaseReplyQuery with TOP and COUNTok Khurram,   what is the internal functionality  top function ,   supose we fired a sql query " sel top 10 * from emp"  emp table having 100 record, it's pic...
2708 Jan 2014 @ 01:07 PSTAnalyticsReplyCall a macro from a stored procedure?ok raja,   suppose id=1  column condition is true than call the emp table , id=2 i struee than call the dept table how ?
2606 Jan 2014 @ 08:43 PSTAnalyticsReplyCall a macro from a stored procedure?hi,   i have aquery_Table   id           date                       query 1   &nbs...
2524 Dec 2013 @ 09:16 PSTAnalyticsReplyCall a macro from a stored procedure?Thank u Dieter,   1.and as well as macro inside another macro? 2.we are using DDL in Macro?   Ratnam
2424 Dec 2013 @ 03:53 PSTAnalyticsReplyCall a macro from a stored procedure?Hi ,   can i call a stored procedure with in the macro ?   ratnam
2323 Dec 2013 @ 07:02 PSTDatabaseReplyQuery with TOP and COUNThi khurram, what is the differece B/W TOP,SAMPLE FUNCTIONS MECONOSAM LEVEL?     Ratnam
2223 Dec 2013 @ 06:59 PSTDatabaseReplyTop FunctionHi,   what is the differece B/W TOP,SAMPLE FUNCTIONS MECONOSAM LEVEL?     Ratnam
2119 Dec 2013 @ 09:58 PSTDatabaseReplydiff between USI and NUSIThqu 
2019 Dec 2013 @ 09:54 PSTDatabaseReplyIndex Cocepts in TeradataHi all,   can you tell me bellow mentioned which one is better ? merge join or hash join or nested join     Ratnam
1919 Dec 2013 @ 09:52 PSTAnalyticsReplyFast Load Vs Multiloadthku Raja, Q : compleate row duplicates 50 records in my file  using fastload after executing script log information has given 49 record as duplicated count and 1 record will go to UV  e...
1818 Dec 2013 @ 09:14 PSTAnalyticsReplyFast Load Vs MultiloadHi Raja, if i ahve a data like  total 100 records 1. 50 records complete row duplicated. 2. 10 records data type is different . 3. 40 records unique and good data.   my...
1718 Dec 2013 @ 07:28 PSTDatabaseReplyBteq script - error handling not working, need helpThanks Raja
1618 Dec 2013 @ 07:25 PSTDatabaseReplyIndex Cocepts in TeradataHi all,   1.  Teradata which join is better ? 2. Default teradata which join taken ?   Ratnam
1511 Dec 2013 @ 07:21 PSTDatabaseReplyBteq script - error handling not working, need helpThanks Khurram, i need another script, i have a job_status,target tables  based upon the target loading depends upon job_status table  i want first check with job_status table (it'...
1411 Dec 2013 @ 09:57 PSTDatabaseReplyBteq script - error handling not working, need helpusing BTEQ Script, any changes (insert/update/delete)-how to get ACTIVITYCOUNT  every changes how to get TABLE ACTIVITYCOUNT ?  
1310 Dec 2013 @ 06:34 PSTToolsReplySQL Assistant 12.0which OS you are using currently ?  
1210 Dec 2013 @ 10:04 PSTDatabaseReplydiff between USI and NUSIHi Dieter,   can u e explain why NUSI takes all AMP Operation, give me Best example    Thanks Ratnam
1106 Nov 2013 @ 09:56 PSTDatabaseReplySimple QueryHi all, we have d_emp table with 1000 records . just i wrote a qurey  sel top 10 * from d_emp; where it filters in 10 records ! directly filters base table (or) total 1000 records get spo...

Pages