#DateForumTypeThreadPost
72326 Apr 2014 @ 10:10 PDTDatabaseReplyuser creationYou need to put the following command in a macro/SP, havent tried that if there is any limitation for it in SP/Macro .... but command is fairly simple:   CREATE USER marks  ...
72224 Apr 2014 @ 12:21 PDTDatabaseReplyThrottle LimitsTDWMThrottleStatistics contains some info  .... but am not sure how you can link it with Profile.
72124 Apr 2014 @ 12:14 PDTGeneralReplyConverting Oracle SQL*Loader scriptsI dont think there exists any tool/script .... even if it does am sure writing 40 Fastload/TPT scripts would be much faster as commpared to converting, testing, finding issues and then re-doing scr...
72021 Apr 2014 @ 11:23 PDTDatabaseReplyNeed Help on Below Senario ?Can you share sample input and output you desire?
71921 Apr 2014 @ 10:43 PDTDatabaseReplyHow to execute multiple macros in single statment.You can have conditional logic [IF or CASE] either in SP or BTEQ script. For your scenario BTEQ script would be the workable option.
71821 Apr 2014 @ 10:41 PDTGeneralReplyCase statement with multiple elsePlease have a look at following link, it explains the CASE statement:   http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1145_111A/ch02.072.01.html
71721 Apr 2014 @ 03:57 PDTTeradata ApplicationsReplyTable properties and utilities to load dataI dont think these attributes will have any significant impact on loading times. Bulk load through FastLoad or TPT is always going to give you far better performance as compared to other methods.
71621 Apr 2014 @ 03:54 PDTThird Party SoftwareReplyBi tool cannot read from different databases in teradata?Its you choice to have views inn same or different DBs .... what i wrote above is that usually its 1 DB for tables .... and another seperate 1 for all the views.   Regarding BI limitation, y...
71520 Apr 2014 @ 06:22 PDTUDAReplyLoading Unicode data from Oracle to teradataYou can verify your loaded data using CLI based connectivity i.e. BTEQ.   Also, about the setting that Qaisar has mentioned .... you need to go to ODBC -> Edit TD connection -> Change ...
71420 Apr 2014 @ 06:18 PDTUDAReplyETL CLOB from Oracle to TeradataPlease have a look at following link:   http://developer.teradata.com/tools/articles/large-object-loading-with-teradata-parallel-transporter
71320 Apr 2014 @ 06:17 PDTAnalyticsReplyExit handling routineAssuming you have all the error-tables in the Drp_Tables table .... you can export it as a text file and using an OS based script .... shell script .... you can send that list as an email.
71220 Apr 2014 @ 12:26 PDTDatabaseReplyTo compare data in different columns for different rows of records:You can achieve that using self-join with a condition you mentioned above. To get the count you will be required  to have a nested SELECT or derived table, and count the MBR_IDs in upper SELEC...
71120 Apr 2014 @ 12:06 PDTGeneralReplyCompare current row with previous row in TEradataAlso, PREV_PK_COLUMN_V is not an Informatica variable, so also state whats the source of this column.
71020 Apr 2014 @ 12:04 PDTGeneralReplyWhen we need to collect stats on tableIt is available in  14.10 version. For further details visit:   http://developer.teradata.com/blog/carrie/2013/12/easing-into-using-the-new-autostats-feature
70919 Apr 2014 @ 11:59 PDTGeneralReplyCompare current row with previous row in TEradataIs there any sorting being done in Informatica before this transformation?
70819 Apr 2014 @ 11:58 PDTGeneralReplyBTEQ Script is failingIndeed you need to have tables created and only then you can use them in SQL.
70719 Apr 2014 @ 11:56 PDTDatabaseReplyTeradata Temporal ErrorFollowing should work:   CREATE MULTISET TABLE Policy( Policy_ID INTEGER, Customer_ID INTEGER, Policy_Type CHAR(2) NOT NULL, Policy_Details CHAR(40), ...
70619 Apr 2014 @ 11:07 PDTDatabaseReplyRegarding date formatDear, your hiredate is of year 2013 and current_date would definitely be of year 2014.
70519 Apr 2014 @ 10:59 PDTDatabaseReplyPrimary Index on VARCHAR columnInteger literals take less space as compared to charater literals.   For example, INT takes 4 bytes and CHAR(10) would take 10 bytes .... which effectively means more data to store, retrieve...
70419 Apr 2014 @ 12:19 PDTDatabaseReplySkew FactorPI is selected to give you bettter distribution and more importantly less or no re-distribution while using table. As its a stage table, you need to check transformation rules to know which colymns...
70319 Apr 2014 @ 12:14 PDTGeneralReplyHow to copy a file from host to Teradata Express for VMwareUsing VM Ware -> Manage -> Virtual Machine Settings -> Options -> Shared Folders .... you can have a folder shared between host & guest OS.
70218 Apr 2014 @ 11:26 PDTGeneralReplyNo Spool space errorSkewfactor can also have a larger values if the data-set is small. How many AMPs you have on the system? And can you execute and share result of bellow SQL:   SELECT col1, col2, col3, COUN...
70118 Apr 2014 @ 11:21 PDTDatabaseReplyTeradata Temporal ErrorWhat is your TD Version?
70018 Apr 2014 @ 11:20 PDTDatabaseReplyScemantic Layer in Teradata Data WarehouseThe idea of DWH, usually is to contain as detailed data as possible, so you can answer any future reports using the same detailed data. Hence we say DWH models actual business and it is as per the ...
69918 Apr 2014 @ 11:12 PDTDatabaseReplyOne record dropped on import function-can't figure out whyCan you please clarify 'import process'? Are you talking about SQL Assistant import?   Is it the file that youu are importing? Does the file have empty-line at the end?

Pages