DSXchange

The output data type needs to be string of some kind. You can not prepend zeroes to a numeric data type - they are stored internally in binary format. ... Thanks Ray! We were having the output data type as Char and i saw your lines on the other thread prepend zeroes to a numeric data type - they ar...

See if you can see the stages in Designer in the Repository\StageTypes\Parallel\Processing. If you can see it there, try dragging it onto a job design. If that works, you can also drag it over to a category on the Palette (where you'd usually see it) -Craig Yes Craig,As i have mentioned,we are able...

ray.wurlod wrote:DLLs are sometimes tricky. Have you re-started the client machine in the meantime? ...

Yes Ray we did that couple of times...

No Luck.. .....Thanks looking!

Just to bringing back on top... Any help would be appreciated!

In the "Execution" tab under job properties, there is a text-box named "Advance Runtime Options". I have a job to test, where i find #DSProjectARTOptions# is being used for "Advance Runtime Options". Can anyone please tell me what is it actually? :?: :arrow: :arrow: DSP...

in the row generator uyou will be able to specify the data type as integer!
also you can use some function like decimal_from_string to get the numeric output!

In the developers guide you will get a lot of info.

Edi

As said,Requirement is not clear!
since you said you need to do something in transformer,Trim could be the best choice.check the guide it has lot of options.

Edi

hi is it possible to handle nulls and conversion from decimal to int on a single column in modify stage. please help me. i have a case where my column is DLV_ORD_LIN which is a decimal and i have to convert that to int as well as i have to handle nulls together in modify stage. thankyou prasad In t...

There could be 2 possibilities... There might be something wrong on specifying apt config file.. did u specify the parameter as $PROJDEF or something else Try to give the whole server path where your config file resides. the "trouble Creating file" error may occur if you don't have suffici...

Click on More on the Compile window and do post the Error message you are getting..

Edi

opps..I missed that!!

Define the meta data using the Schema file property and Define the Field name and Length on the output LInk...

Edi

Dear All,

we will be able to copy dataset data form all nodes using "Dataset management"
But when i am doing that, I am getting the column name on each row of data..
Is there a way to copy a data as it is..I mean without the column names on each record?

Thanks in advance,Edi

Is creating time variant snapshots or respective tables for conformed Dimensions and Conformed facts the answer to the above. Or is there any other approach to resolve this. Can anyone also let me know if we need a holding area where we can hold one set of fact and conformed dimensions while the oth...

Kenneth, So, in this case, I should go ahead and create two physical tables using the same conformed dimension structure.

Can create a multi instance job, one for daily and the other for Monthly to populate respective dimension tables?

Am I right?