221 | 19 Nov 2013 @ 08:44 PST | General | Reply | Process of Change of PI in skewd table | You 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... |
220 | 19 Nov 2013 @ 07:13 PST | Database | Reply | Manual Data profiling queries | Hi Nagesh,
You can use help column dbname.tablename.* to get the required data.
Cheers,
Raja
|
219 | 19 Nov 2013 @ 07:04 PST | Connectivity | Reply | Teradata connectivity with SAP | Hi,
Do you see this posting, in the same forum:
http://forums.teradata.com/forum/tools/diacritic-character-issue-multiload-bods
Cheers,
Raja
|
218 | 19 Nov 2013 @ 07:00 PST | Tools | Reply | Diacritic character issue multiload BODS | Pranil,
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 ... |
217 | 18 Nov 2013 @ 07:50 PST | Data Modeling | Reply | Financial.... LDM | Thanks Sebastian.
Regards,
Raja
|
216 | 18 Nov 2013 @ 07:47 PST | Connectivity | Reply | Teradata connectivity with SAP | Yes. 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... |
215 | 18 Nov 2013 @ 07:57 PST | Tools | Reply | Diacritic character issue multiload BODS | Hi,
Did you use vartext, text from the drop down? Try those and let us see.
Cheers,
Raja
|
214 | 18 Nov 2013 @ 06:51 PST | Tools | Reply | Creating warehouse upgrade scripts | Hi,
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... |
213 | 18 Nov 2013 @ 06:40 PST | Connectivity | Reply | Teradata connectivity with SAP | Hi,
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... |
212 | 17 Nov 2013 @ 10:16 PST | General | Topic | How 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
|
211 | 17 Nov 2013 @ 08:37 PST | Tools | Topic | tpt from cloud | Hi,
Can I use tpt from cloud? How can it be done?
Thanks and regards,
Raja
|
210 | 17 Nov 2013 @ 08:26 PST | Connectivity | Topic | Loading from oracle to TD using TPT | Hi,
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
|
209 | 17 Nov 2013 @ 08:15 PST | Third Party Software | Topic | ETL tools for big data | Hi,
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
|
208 | 17 Nov 2013 @ 08:10 PST | UDA | Topic | PDCR | Hi,
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
|
207 | 17 Nov 2013 @ 08:03 PST | Cloud Computing | Reply | Cloud and Big Data Symposium | I 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
|
206 | 15 Nov 2013 @ 09:37 PST | Data Modeling | Topic | Party | 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,... |
205 | 15 Nov 2013 @ 07:36 PST | Database | Reply | Increase the size of DBC | Hi 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... |
204 | 15 Nov 2013 @ 07:27 PST | Tools | Reply | generating sequention number during mload | Hi,
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 ... |
203 | 15 Nov 2013 @ 07:22 PST | Tools | Reply | Utilities interacting with mload | Tom,
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... |
202 | 15 Nov 2013 @ 07:08 PST | Database | Reply | regarding the conversion of currency from INR to n e other currency | Hi,
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... |
201 | 14 Nov 2013 @ 10:48 PST | Tools | Reply | Problem 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... |
200 | 14 Nov 2013 @ 09:19 PST | Data Modeling | Topic | Financial.... LDM | Hi,
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... |
199 | 14 Nov 2013 @ 09:12 PST | Analytics | Reply | INSERT 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.
&... |
198 | 14 Nov 2013 @ 08:39 PST | Tools | Reply | Utilities interacting with mload | Hi,
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 ... |
197 | 14 Nov 2013 @ 08:23 PST | Database | Reply | Tools to compare two teradata's DB and find the differences | You are always welcome. The above one is just a skeleton. You could have added more features , to serve automation.
Cheers,
Raja
|