DSXchange

hi all, when am loading the data into oracle oci database its throwing an panthom warning like... DataStage Job 1116 Phantom 18491 Program "JOB.2013283459.DT.1533610691.TRANS13": Line 246, Nonnumeric data when numeric required. Zero used. Program "JOB.2013283459.DT.1533610691.TRANS13&...

HI , i have a job, which fetching the data from hash files doing some conversions and finally load into the taret table, my target is oracle database , i used oracle oci stage to load this data, its throwing below error "ora-12154 tns could not resolve the connect identifier specified" i h...

Set the NLS_LANG parameter and specify the proper character set as AMERICAN_AMERICA.AL32UTF8

Hi all,

could any one explain me what is usage analysis in datastage, how it will use .i searches all the forums but i didn't get solution.

Thanks advance to alll

Try to use transforner stage by cretating the two stage variables. STRV1 - which is used to identifie the unique records STRV2- which is used to concatenate the col1,1ol2,col3 for the same key column when the fields doesnot have null value. Finally create a out fields four F! - contains key value F2...

Applied parallel transmition

with in the trasformer just write a constraint with the datefield ,let us suppose your input date range is 3 day s and your inputdate like jan 1 to jan 9then you have to write constraint like substr(inputdatefield,1,3) = 'jan' and (substr(inputdatefield,3,1) = 1 or substr(inputdatefield,3,1) = 2 or ...

better to use constraints with in the transformer stage.
some thing like date range between oct 3 to oct 6.

my datastage server located on windows.

hi, i need a simple clarification on about reading .xls files on datstage environment, which are resides on my windows server . i created a system dsn for xls files in the odbc administrator , when i use the odbc stage to read this fiels i have been asking the credentials like dsn name,user name,pas...

iam not aware of these stuff, let me know if you have any idea around this

just wok with ps-ef | grep <username>,which gives all the process id's running on your server

no, iam not runninng any kind of virutalization software.let me conform one thing is it possible to install server components in sun o.s then client components in windows and configure both on my home made pc.
any one could clarify me.

there is only one way to invoke jobs,which are already opend by some one,find out the process id for corresponding job and then open that job.
specially there is no mechanism in datstage to fulfill your reqirement.

what steps you have taken to resolve this issue could you let me know .