DSXchange

Dear All, I have two different application systems sending message with same format. Requirement is to append Application 2 input to Application 1 input at output. Application 1: <AddressDetails> <Address> <City>chicago</City> <State>illinois</State> <Country>US</Country> </Address> <Address> <City>...

I am having a dataset one of the column names is ID whose values are like 000123, 000124 etc.. This is of DataType numeric. I have a table to which I need to do a lookup using these values.. table has values like 123, 124 etc.. This is of data type VarChar. So from the above dataset input I need to ...

How can we convert Numeric to VarChar in DataStage?

Please help!!

Thanks, Raj

Hi All, Thanks for the suggestions you gave to resolve this. I followed three approches to make sure all are giving same results. And All gave same results :) 1. Using Sort and Filter stage. In sort stage I had set Create Key Change column to True. In Filter stage using KeyChange attribute i routed ...

Hi All, Thanks for the suggestions you gave to resolve this. I followed three approches to make sure all are giving same results. And All gave same results :) 1. Using Sort and Filter stage. In sort stage I had set Create Key Change column to True. In Filter stage using KeyChange attribute i routed ...

Thanks for answering.

Sorry for being stupid.

Could you tell me how can we compare each record with the value of the previous record in Tx stage?

Hi I have a CSV file. I need to find if there are any duplicates in the files. If any duplicate records are present I need to reject them and put into a sequential file.

Can any body let me know hoe can i do this in DataStage8.1 version?

Thanks, Raj.

Hi Prakash,

Thanks for the response.

Yes your assumption is right. I wanted to check if the value already exists and insert newer records. Using upsert I thought of overwriting them, but didnt work.

I didnt get what is change capture. could you explain in detail.

Thanks, Raj.

Hi, I have a table (ORDER_DETAIL) which has only one column (ORDER_NBR) and is not defined as Key in Database. I wanted to do an upsert to the table. when I do so the Update SQL is is showing Missing Key Columns. UPDATE #$SchemaName#ORDER_DETAIL SET ORDER_NBR = ORCHESTRATE.ORDER_NBR WHERE (<<Missing...

Hi All,

I am trying to convert string to decimal using transformer stage.

The StringToDecimal() function says to give Rtype as second argument. What is this and how how do we define this?

Please help!!

As I am new to DataStage unable to understand the lingo.

-Thanks!!
Raj

In a csv file, I am having a date format as month day, year (for ex: January 14, 1940)

But as this is a csv file it is considering January 14 as one attribute value and 1940 as another attribute value.

How can I resolve this issue?

-Thanks,

hahaha good one!!

but iam not appearing for any interview...

I am new to DataStage and trying out things...

Both input and output are of type Date.

Can you help me now?

Hi Iam trying to convert String to Date using Modify Stage. And the function which iam using is Date:Date=date_from_string[%mmm %dd, %yyyy](Date) My input format is of string and is like June 14, 2010 when I run this it gives a warning saying Data string 'June 14, 201' does not match format '%mmm %d...

What function can I use to convert date from Mon dd,yyyy to YYYY-MM-DD?

-Thanks
Raj

anbu wrote:map decimal directly to an integer field in target

What exactly happens when I map directly decimal to integer. Is it rounding off the values or truncating the precision part?

thanks for the response.