#DateForumTypeThreadPost
22119 Nov 2013 @ 08:44 PSTGeneralReplyProcess of Change of PI in skewd tableYou can use hashamp....hashbucket.....hashrow for a field and see how it is distributed per amp and how the skewedness is.  Once you get the best, then you can proceed with recreating the tab...
22019 Nov 2013 @ 07:13 PSTDatabaseReplyManual Data profiling queriesHi Nagesh, You can use help column dbname.tablename.* to get the required data. Cheers, Raja
21919 Nov 2013 @ 07:04 PSTConnectivityReplyTeradata connectivity with SAPHi, Do you see this posting, in the same forum: http://forums.teradata.com/forum/tools/diacritic-character-issue-multiload-bods   Cheers, Raja
21819 Nov 2013 @ 07:00 PSTToolsReplyDiacritic character issue multiload BODSPranil, Is it not available at Target Table Editor? So may options are there.So many options are there. Also which version are you working with? I work on 3. something . So , please check in ODBC ...
21718 Nov 2013 @ 07:50 PSTData ModelingReplyFinancial.... LDMThanks Sebastian.  Regards, Raja
21618 Nov 2013 @ 07:47 PSTConnectivityReplyTeradata connectivity with SAPYes. It supports mload,fload etc.Try for push down as much as possible. This tool has got few limitations. I have made few suggestions for improvement on the tool when I used to work in 2010. &nbs...
21518 Nov 2013 @ 07:57 PSTToolsReplyDiacritic character issue multiload BODSHi, Did you use vartext, text from the drop down? Try those and let us see. Cheers, Raja
21418 Nov 2013 @ 06:51 PSTToolsReplyCreating warehouse upgrade scriptsHi, I think  versioning tools like VSS, PVCS,SVN, CVS etc will do since you do check in and check out and you can compare easily. You can deploy. I wrote the end to end code promotion for a p...
21318 Nov 2013 @ 06:40 PSTConnectivityReplyTeradata connectivity with SAPHi, How about SAP DS( BODS). I usually used SAP DS when I worked in one project. The speed is slow. We wrote an ABAP flow and it works like a charm. I think it comes free with other SAP suite. Ch...
21217 Nov 2013 @ 10:16 PSTGeneralTopicHow to post a blog?Hi, I want to post a blog here. May I know how I can do it? I just want to share my thought. Thanks and regards, Raja
21117 Nov 2013 @ 08:37 PSTToolsTopictpt from cloudHi, Can I use tpt from cloud? How can it be done? Thanks and regards, Raja
21017 Nov 2013 @ 08:26 PSTConnectivityTopicLoading from oracle to TD using TPTHi, If I have 500 GB of data to be tptied to TD, how much shared memory from the client system, should I allocate? Thanks and regards, Raja
20917 Nov 2013 @ 08:15 PSTThird Party SoftwareTopicETL tools for big dataHi, May I know the ETL tools that have API connectivity to big data? for example Ab Initio, Informatica, SAP DS etc. Thanks and regards, Raja
20817 Nov 2013 @ 08:10 PSTUDATopicPDCRHi, I hope PDCR provides  performance and capacity reporting. May I know if I can configure or replicate the Dev and QA env with this? TLE ????? QCD???? Thanks and regards, Raja
20717 Nov 2013 @ 08:03 PSTCloud ComputingReplyCloud and Big Data SymposiumI wish I can attend. I used to work in Richmond before in Capitalone way back in 2007,2008. I have so many questions on Big data integration. Thanks and regards, Raja
20615 Nov 2013 @ 09:37 PSTData ModelingTopicParty Hi, I think with this attribute "Party Related Role Cd" in Financial LDM, I can maintain the hierarchy in all entities. Can you please let me know the pros and cons? Thanks and regards,...
20515 Nov 2013 @ 07:36 PSTDatabaseReplyIncrease the size of DBCHi Dieter, You are my guru. I don't know much about SYSINIT. Is it that utility where we can configure the DBS variables  and GDOs on the screen and have multiple choices? Once it is done...
20415 Nov 2013 @ 07:27 PSTToolsReplygenerating sequention number during mloadHi, I can't think of a solution. I have never encountered this problem. Did you have a look at mload SYSTEM variables(&SYS) if any luck. Else I think of  a logic post mload, based on ...
20315 Nov 2013 @ 07:22 PSTToolsReplyUtilities interacting with mloadTom, Thanks for the clarification but I see in the document now that it says I heard this from someone but I look at the document I found the underlined statement below. Maybe it is meant to inte...
20215 Nov 2013 @ 07:08 PSTDatabaseReplyregarding the conversion of currency from INR to n e other currencyHi, How about joining on currency_code, start_date and end_date with source_code,start_date and end_date of  2nd table and get the calculation ?   Please do verify your data a...
20114 Nov 2013 @ 10:48 PSTToolsReplyProblem using Teradata import - making me crazy!!Hi, Did you  check your file and data? Also you can have a look at the menu:  Tools>Options and then check your import/export. There is a drop-down of delimiters. Select one appropria...
20014 Nov 2013 @ 09:19 PSTData ModelingTopicFinancial.... LDMHi, Are there any upgrade to Teradata Fsldm recently? The last one I saw was having these SAs: Party, Party Assest, Agreement, Product, Event, Campaign, Channel,Location, Orgainzation,Finance Mgm...
19914 Nov 2013 @ 09:12 PSTAnalyticsReplyINSERT SELECT and other values Hi,   As per my understanding, since there is no TJ/WAL maintenance, because your target table is empty, so it  follows the fast-path. So from that standpoint it is fast. &...
19814 Nov 2013 @ 08:39 PSTToolsReplyUtilities interacting with mloadHi, How about QrySessn? Let it be answered by someone who has better knowledge on mload, if yes then what are those, if no then it ends  with no. I think you have a bad experience with ...
19714 Nov 2013 @ 08:23 PSTDatabaseReplyTools to compare two teradata's DB and find the differencesYou are always welcome. The above one is just a skeleton. You could have added more features , to serve automation. Cheers, Raja

Pages