DSXchange

Hi, I was running a job and it aborted halfway. I tried to run the job again but it didnot run atall. This job was running sucessfully before. I just added 1 extra column this time. When I tried to run the job status in director I got error: Error selecting from log file RT_LOG10197 Command was: SSE...

Could u please explain the funnel logic....I guess Join will be more useful...

here is my requirment

I have records like:

id Fe Zn Ag
1 10 20 30
2 5 6 8


Now I want the records like:

id test value
1 Fe 10
1 Zn 20
1 Ag 30
2 Fe 5
2 Zn 6

there are many columns......20 to be exact.....

Regards,
Arnab.

Well I am partly successful....

I am able to get..

Id Value
1 10
1 20
1 30
2 5
2 6
2 8

But was not able to get Fe,Zn,Ag...etc...as column values....


Regards,
Arnie.

Hi, I have a complex requirment. I have records like: id Fe Zn Ag 1 10 20 30 2 5 6 8 Now I want the records like: id test value 1 Fe 10 1 Zn 20 1 Ag 30 2 Fe 5 2 Zn 6 2 Ag 8 Can we do that in Datastage.....Please help... Regards, Arnie.

Actually I want to run a job that will create a table in sql server.
This table will be used to generate reports. But for the next run I want to drop the existing table and re-create the same table.
Could please tell me how to do this....have never tried this before...

Regards,
Arnie.

Hi,

Is it possible to drop and create table?

Regards,
Arnie.

Hi , I am not able to figure out this error. CopyOfTransform_XL_TU_EqpmntTmap_v2..x_Transform.lXL_EU_MachineryTypeGroupMappingInsert: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO MatEqpmntTmap(EquipmentTypeAssociatedId, EquipmentTypeId) VALUES (?,?) SQLSTATE=22005, DBMS.CODE=0 [Da...

Hi ,

I have a join. Left key field is an integer fields,len 4 and right key field is a varchar,len 50. The join is not working even after trimming the right records. I guess the right records have got some special characters with them.

Please help.

Thanks,
Arnie

Hi,

I am gettin compilation error in Link Collector stage like:

Link Collector stage does not support active to active input or output

Please help.

Tharks,
Arnaie.

Yes sir

Hi,

I have a column like QDL Marine and Static Diesel Engines (In).
Now I need to make it like QDL Marine and Static Diesel Engines (In).The length of this value differs from record to record.

I tried with convert but then it become QDL Marie ad Static Diesel Egies.

Please suggest.

Thanks,
Arnie

data type is Timestamp 23,3......

any way to remove the millisecs....?? But the target is seq file here (intermediate job),so I guess the millisecs getting added in the transformer...

Thanks for the reply....

what I observed is very starnge...

2008-09-04 07:57:00.00 is getting converted to 2008-09-04 07:57:00.000000......althougt there were no transformations involved...just straight moved in the transformer.....

Thanks
Arnie

Hi, I am getting this err: Load_IPNA_Sample_insert..Transformer_36: [DataDirect][ODBC SQL Server Driver]Datetime field overflow. Please explain what might have caused it.....I checked several times but unable to figure....especially when more that half of the records got inserted with the same kind ...