DSXchange

by making read method as file pattern or by increasing of readers

Thanks Priyadarshi Kunal And pandeeswaran

after rerunning of job its working fine

Thanks

my job is orc enterprise--lookup--Dataset

while running the job iam getting the following error

"(aptoci.C:561). Message: ORA-08103: object no longer exists"

can please suggest me how to fix it


Thanks

can you post what Exact input and what exact output do you want

in pivot stage make the "name" field datatype to varchar(50) and map

n1,n2,n3 into it

as mentioned above change colum n1 as "name", colum n2 as "name", colum

n3 as "name", then funnel will show the c1,c2,name

source----copy------funnel---output

take three links from copy stage

1st link c1,c2,n1(name)

2nd link c1,c2,n2(name)

3rd link c1,c2,n3(name)

after that in funnel stage combine the data and pass to output

if st1 is null then SAL else st1+SAL--------st1

(OR)

if @inrownum=1 then SAL else st1+SAL--------st1


map st1 to sumcolum

make sure the data should be sorted based on SAL

Getting Error:-
Ignoring duplicate entry at table record 3; no further warnings will be issued for this table

Why above warning will come and what need to do to supress that one

Thanks

Thank You Somuch vamsi

Hi zulfi,
here whats the use by giving of third parametre 'A'

Thanks

Hi, I had created a table in the oracle database one of the field in that table is valdate datatype of that field i had given date but when iam importing that table definition into datastage it automatically coming as timestamp can please help me how to import that table definition as date datatype ...

what the import wizard is doing is correct as thats how it is interpreted in it. Oracle database's date can store date as well as time component hence the equivalent of it will be timestamp. A timestamp in oracle can store fractional seconds for which you need to use the extended property of timest...

Hi, I had created a table in the oracle database one of the field in that table is valdate datatype of that field i had given date but when iam importing that table definition into datastage it automatically coming as timestamp can please help me how to import that table definition as date datatype ...

Thank you somuch i think it should work i will try iit now and i will come back with result