DSXchange

Thanks for the clarification.

If i enabled execution mode as parallel for DB2 API stage then is there any performance improvement. I could see default execution mode is Sequential.

Hi Experts,

I have 0.5 million records. I am planing for job design as follows.

Dataset --> Transformer --> DB2 Stage

My target table is not Partitioned. Please suggest me, Whether DB2 API stage or DB2 Enterprise Stage would give more optimisation.

It solved my problem.

Yes, My main worry is how to pick either first/ last 2 records from each group "CNO". Could any one give some light on it.

Thanks for your input. As per your suggestion, I will do sort based on CNO and ENTRY_TIMESTAMP in reverse order(Desending order). How to pick first "X" records for each CNO.

Hi My source and target are csv file. It contains the data as follows. CNO CNAME RISKRATINGS ENTRY_TIMESTAMP 100 , ABC , 2 , 2011-02-03 10:15 100 , ABC , 3 , 2011-02-02 10:10 100 , ABC , 1 , 2011-02-04 12:15 101 , XYZ , 2 , 2011-02-03 10:12 101 , XYZ , 3 , 2011-02-04 16:13 For each CNO i want last 2...

I am assuming Date1 and Date2 attributes are varchar and provided the below Derivation.

Derivation: DaysSinceFromDate(StringToDate(Date1,"%mm/%dd/%yyyy"), StringToDate(Date2,"%mm/%dd/%yyyy"))

This function returns the interger (int32) value.

Hi ArndW,

Thanks for your inputs and time.

Thanks
Ravi K

Hi Andrew,

The conversion is taking place implicitly.

How can we explicitly convert unsigned int32 to a signed int64? Is there any function available. If yes, kindly confirm the function.

Thanks
Ravi K

I Managed to resolve the warning. At target side also i defined it as uint64 as "Datatype is BIGINT and enabled Unsigned at Exteneded option of Columns Tab " rather than converting to int64(BIGINT). Really is there any conversion functions available which is used to convert uint64 to int64...

you are absolutely right. It is automatically converting uint64 to int64 and result is also fine.But i am getting a warning as below. When checking operator: When binding input interface field "ROWNUMBER_COL" to field "ROWNUMBER_COL": Implicit conversion from source type "ui...

Actually i am using "Row Number column" property of Sequential file to generate Sequence Number. The "Row number Column" produces unsigned value like uint32 or uint64. I need to forcefully convert uint64 to int64 why because i could not locate Extended option at Sequential file c...

Use variable acvity and apply functions like iconv, Oconv then you easily get it through. if you need full information on iconv and oconv then refer the documentation. it clearly explained.

Thanks
Ravi

Use Change Capture Stage, Identify which is before dataset and after dataset. Based on the codes provided by Change capture stage then direct the data to the respective inserts and updates.

Thanks
Ravi

Hi All, I am trying to load data from Sequential file to DB2 Database with the help of DB2 API stage by using update action as Insert rows without Clearing. My file has 50,000 records. When the load was at 45,000 record the job got aborted due to some reason. Then we are reloading from scratch.(we p...