Hi
can any body help in to resolve the error.I getting the following error. Actually i need to copy some files from another server to local & then these files to be populated to ODS. When execution of same package was perfectely working fine(populating data to ODS) but when iam scheduled these...
Hi to all
I Have a flat file as a source ,the folling r the field items are userid, Ipadd,Time,st_flag and sample data looks like as follows.
Userid~IP Address~Time~status flag
e039373~137.019.214.065~Jul 23, 2003 10:25:18~D
e039373~137.019.214.065~Jul 23, 2003 10:30:18~D...
Hi to All
I want to concatenate the values of 2 columns(col1 & col2) in the 3rd column(col3) internally. can it possible ? then how?
for eg.:
table is : xyz
col1 col2 col3
1991 3 19913
1991 4 19914
2000 1 20001
2000 4 20004
.....
....
...
Thanks In advance
Mano
Hi to all
can any help me regarding how to use substr,instr in queries in " where condition".acutally i need get data from tables for across the yearwise like apr2003-feb2004 etc..
thanks
Mano
Hi to All
This is the first time iam entering into this forum, Iam Oracle DBA ,can anybody tell me more about teradata , how it works internally, wat files its going to read before starting the database,i gone through some of the utilities like WINDDI,BTEQ,Queryman,Fastload,tPump,Teradata...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.