DSXchange

Hi,
Montior just tells you how many rows are getting insert or updated , Never tells you how many rows are processed by each node,

Hi,
How can i see how may rows each node is processing.

Thanks

ok , someone suggest to remove partiton but instead use datset with multiple node,any suggestion on that

ok, any way we can do via datastage

Hi, I want to create dynamic partitions , Currently my partitions are based on snapshot period which is year and week combination like (20091,20092,20093 and so on), But we want to have keep just last 12 week and then delete previous week, so that means we really want only 12 partitions and that par...

Hi there
My sequence jobs are failing due to error below

Job control process (pid 794996) has failed

any idea how can i see details as of which job this pid is ?

Hi,
I exported full project as dev.dsx and was finding for a string like opps(5,10,11) and i did find it , But i am unable to find the build name in which
this sql is ? Any easy way to find it?

Thanks

Hi Ray,
So where we should look for resource file then?

Hi Ray,
So where we should look for resource file then?

Hi,
i just migrated form 7.5.1 to 8 , complied the jobs and ran them
getting warnings below any idea what can be wrong

DSD_GenerateEvents.B:LinkReport for XTR_ktr.ktr_brand.out_brand not found.

yes i am trying to convert column with '' to 'N'

I am using database and when i say null i mean its coming blank from one database and i want convert that blank to 'N' to other database so when i do this it still is not converting to 'N' IF IsNull(lkp_EIW_Valid.EIW_MATCH) Then 'N' Else if Trim(lkp_EIW_Valid.EIW_MATCH) = ' ' then 'N' else Trim(lkp_...

Hi there Isnull function dont give desire result in transformer but when i run update on database give desire result ,Any idea whats wrong? (Donot give require result) IF IsNull(lkp_EIW_Valid.EIW_MATCH) Then 'N' Else if Trim(lkp_EIW_Valid.EIW_MATCH) = ' ' then 'N' else Trim(lkp_EIW_Valid.EIW_MATCH) ...

ok
so what i want is sumthing like this
LOCATE(';',AL3.CMPPLNMPIDS) = 0
but datastage dont like this function so what can be work around

Hi There,
I am getting input data like below i want to filter output like below please advice

Thanks,

Input data

101EH
101F7; 101FC; 101FX
101EY

output data

101EH
101EY