DSXchange

I am not a premium user. Can you please share the solution with everyone including non premium user.

Hi,

We have the sample record like the one below.

"10","vino","apple","ram"


Delimiter is ","

How do we interpret the same in DS.

Can you please help us to sort this issue?

Yes. But will it possible for us to run a full korn/perl script on the data within a job. For example, we need to remove some unwanted characters from the input data stream to the output only through a perl/korn script. If this is the case, can we use the same stage mentioned by you. Please clarify....

We ve the flow is as follows?

Source------>Transformer---->perl script/Unix script----->Transformer---->output.

Which stage should i use to run the perl/unix scripts in DS.

Is there any explicit stage avail in DS?

I can able to complie the parallel job and not able to run the job. So I am not able to find my syntax is correct or not.

We have given the syntax as

SUBSTR(Column_name,2,4) like '___='.

we cannot run the parallel version here. We are not sure whether our syntax is correct or not.

Should we use the following syntax.
Column_name(2,4) like '___='

Can you please help me out which one would suite in DS.

Thanks,
Vino

Hi, We just want to know whether the substr function will be used in Filter stage. We want to filter out the records which contains substr(column_name,12,4)like ___=. If the record satisfy the above condition then it can go to next stage else it should move to reject file. Please let us know whether...

Hi.

while using the compresser stage to compress the flat file and stored it in data set, we are getting the following error.

Job level message handler Nxrp_suppress_Implicit_Conv_Warning.msh not found .

Can you please help us out to solve the problems.

Oracle_Nxrp_Trn_Tgt_Mns_Pbip_Rej_Dtl: When checking operator: When binding input interface field "YR" to field "YR": Implicit conversion from source type "int64" to result type "decimal[10,0]": Possible range limitation. we have gone through the previous posts...

We got the error saying that OCI has fetched truncated data.
Wegot this error for some of the records. Others records are inserted into database.Help me out to solve this issue

Oracle_Src_Nxrp_Trn_Vce_Avl_Dtl: When checking operator: When binding output interface field "TIME_KEY" to field "TIME_KEY": Converting a nullable source to a non-nullable result; a fatal runtime error could occur; use the modify operator to specify a value to which the null shou...

It works but we need to eliminate these kind of warnings. "Jn_Tgt_Lkp_Ins: When checking operator: On input data set 1: When binding input interface field "ABU_KEY" to field "ABU_KEY": Implicit conversion from source type "int64" to result type "decimal[10,0]&...

While running parallel jobs, we got a lot of warning messages.So after we add the message handler to demote the warnings into info.But we need to remove the warnings not to demote warnings to info.
is this possible to remove or mask the warnings?