Yes ,Owner has access , executing manual was working fine and when iam putting same package to schedule as Job, its giving error which i mention earlier.
Thanks for ur reply
Manoj
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...
Thanks!
But i dont want in query or to write a code but it should copy internally to the col3 while entering the values for the two columns(col1 & col2).Is their any way to do that.
Thanks
manoj
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.