#DateForumTypeThreadPost
1719 Nov 2013 @ 08:49 PSTDatabaseReplyManual Data profiling queriesIn STG table we are defining all columns are Varchar only .But to Target we need to define base upon the data
1618 Nov 2013 @ 11:18 PSTDatabaseReplyManual Data profiling queriesThanks Raja for u r help. I need one more query to find the data pattren ( INT,CHAR,DECIMAL and DATA). If any query Please help me
1512 Nov 2013 @ 09:39 PSTDatabaseReplyManual Data profiling queriesMy Mail id is :nagesh.dwh123@gmail.com
1412 Nov 2013 @ 09:36 PSTDatabaseTopicManual Data profiling queriesHi, If anyone have manual data profiling queries Please send me .   Thanks in Advance   Nagesh
1312 Nov 2013 @ 09:35 PSTDatabaseTopicManual Data profiling queriesHi, If anyone have manual data profiling queries Please send me .   Thanks in Advance   Nagesh
1209 Oct 2013 @ 11:18 PDTToolsTopicMLOAD ISSUE Hi,   IN MLOAD while loading we got 10 error records  rejected and loaded into error table. So based upon the sequence number i have deleted from the file and deleted table...
1109 Oct 2013 @ 05:47 PDTDatabaseTopicMLOAD ERRORHi,   IN MLOAD  while loading we got 10 error records  rejected and loaded into error table. So based upon the sequence number i have deleted from the file, and deleted the record ...
1009 Oct 2013 @ 02:16 PDTDatabaseReplyCasting to An integer giving incorrect result.Hi,   I have tried in SQL Assistant and its worked fine for me.   Thanks, Nagesh
906 Oct 2013 @ 07:10 PDTDatabaseReplyHow to spell out numeric value in English words by select query.Please mail u r mail ID :nagesh.dwh123@gmail.com  
806 Oct 2013 @ 07:08 PDTDatabaseReplyHow to spell out numeric value in English words by select query.i am not able to find your mail ID in your profile page  
706 Oct 2013 @ 03:36 PDTDatabaseReplyHow to spell out numeric value in English words by select query.Hi Dieter@could you please share your mail id 
604 Oct 2013 @ 11:29 PDTDatabaseReplyStrong and Weak Join Matches where (Policy.A = Policy.B and Claim.A <> Claim.B ) or  ( Policy.A <> Policy.B and Claim.A = Claim.B )  if  you use "()" then its will give you the result wi...
504 Oct 2013 @ 01:10 PDTGeneralReplyinterview helpnagesh.dwh123@gmail.com Please send me the questions  
404 Oct 2013 @ 01:08 PDTToolsReplyimport huge data very quickly -- Fastload/Tpump/MLOADif u r file is having less than 1000 reocrds goto Bteq. if records more than 1000 and les than 10 lakhs and having some contrains like table is not empty and need to load duplicate records like th...
304 Oct 2013 @ 01:01 PDTToolsReplyRejected Rows in Teradatain TPT we can define error file. This file stores rejected records like data struture mismatch and column lenth mismatched records will store into this error file.
204 Oct 2013 @ 12:57 PDTToolsReplyTable Migration : The string contains an untranslatable characterif we get error like "untranslatable character" then we need to change the data set from LATIN to UNICODE. If we get error like bad character means the data type of the column and data i...
111 Jul 2013 @ 04:09 PDTUDAReplyfastloadFast load has two phases. 1. Acquisition 2.Application In acquisition phase data loads into Amps with out sort. In application phase data loaded into target table with proper hasing and all. ...