DSXchange

rwierdsm So how to convert It..

Hi,

Can anybody tell me how to convert float to varchar..

My input data is coming in Float datatype( sql server ) but target database oracle is it in Varchar format

Hi got this error msg while vewiing the data in Oracle enterprise stage ...

##E TDOR 000172 Access to sys.dba_extents is required but not available; please see your database administrator for select privileges.

Can you tell me how to resolve it ....But able to select the records through TOAD

Hi Yuan.

Environmental level we are defining the parameter for each source system.
For each job anyway we need to defien the parameter value if we are not passing the hard coded value to it ..So i posted that query .

Hi , Atucally My question was ....for example ..i have a job A for that i need to define the jobparameter value those are actually defined in Environmemtal variable as userdefined.....i can do this task machanically for each job ..Now my question is Is there any austomated methed to place these Para...

Thanks for the reply, Actually Iam looking for the Log file name like Ora.XXX.XXX.log every time we run job it creates the Log file ...hOw to know which log file is for with Job ..in director i didnt find any file of name ora..... I can do manual search but it will be very tedious Job... please let ...

Hi ,
Can anybody tell me ..Is there any indication of job name with the log file ... Like if we look into the scratch path where we find so many log file crreated for diffrent job ..How we can find which log file is log file of My Job.....please suggest

Can anybody tell where i can find this "Orchestrate Operators guide 7.5 version" Document

Under Veiw tab ..if you click on Customize option ..from parallel processing BASIC transformer there u can drag and drop into your pallate.

Hi , I have a requiremnt where i have to concatenate all the input columns in to one column.... if number of columns in input is less then no problem .. If the number of coumns exeeds 100 then it is very tedious job..please suggets if any routine or ..any other way to to this... ex.. Input columns o...

HI,
Is there any automated way to take the paramter from the enviromental variable ... rather then manually entering for each job... if we have many number of source systems ... is there anyway (or routine who can serve the purpose)

Have you tried writing it to your target and viewing it there yet?
-->When this not moving into target how will i see.. Yes i moved it directly without any conversion i can see.. 00000000000.

how should i get this in Varchar output

Hi

One of my input records looks like 6.87653e+08 (ODBC , sql server) when i click Veiw data.. datatype of this is Float.
In target i need this value in Varchar format ..How to do this?
and what is "rtype" one of the argument need to pass with DfloattoDecimal

Hi ,

I have record in FLOAT ( 6.11232e+12)
Sourec is ODBC (Sqlserver) and target is Oracle Iam using Oracle enterprise stage

I need the above data in Varchar format .... Im using Dfloattostringnoexp and Dfloattodecimal

None of the above is resolving the issue...
please suggets

Hi I have source as file reading through sequential stage and able to View the proper data... ..and after that passed through Transformer stage while loading into Orcale enterprize stage (Target is Oracle DB) ... while running this job i got these error please suggest the solution for this 0: Export...