DSXchange

thanks..

Hi All,

Is it possible to read and funnel data in sequential file having set
Read Method as "File Pattern" and using .ds and .txt files (having same metadata) ..

Thanks,
Sai.

If you know the particular record you want, you can search using the Find option which appears once dataset is opened.

Thanks,
Sanjay.

can you able to see all records in Source sequential file using View Data?

Thanks,
sanjay.

First sort the records based on the key column whcih is followed by transformer stage.

And use use stage variable and constraint to remove dublicates.

sv1 : Key column
sv2 : If sv1<>sv3 Then 1 Else 0
sv3 : sv1

use constraint as sv2 = 1

-----------------
sanjay

I didnt get what it means 'When record BCD got changed to DCB '

Could you plz explain..

Thanks,
Sanjay.

Hi, In transformer Use 3 stage variables sv1, sv2, sv3 with datatype as integer sv1 : (Input column which need to be groped) sv2 : If (sv1=sv3) Then sv2 Else (sv2+1) sv3 : sv1 Map stage variable sv2 to o/p column GroupId---> 'G':sv2 In transformer select sequential mode in Advance tab Thanks, Sanjay.

Check whether DataStage have FP1(Fix Pack) loaded.
Configure Datastge properly to use PAM

Regards,
Sanjay.

thanks for your information...

Sai.

Hi all, Am in need to use funnel stage in between single inpuut link and a single output link.(It is requirnment to use funnel stage during development as we may have multiple source to funnel in future) But when compiling the job it throws an error "fu_stagename requires a minimum of 2 non-ref...

Thanks for help..

problem resolved...

Hi all,

Could you please let me know hoe to get a Day (Monday,Tuesday) from a date ...Is there any functions in Parallel transformer..I have tried ..but am unable to figure out..

Thanks,
Sai

Thanks Ray..

I didnt created separate file to store the values....

Now its working fine..

Thanks
sai.

Hi, Am trying to generate a sequence of numbers starting from 1 by using surrogate key generator stage. Am having an input column as Emp_Name and in output i need Emp_name numbered as 1,2,3.... The job looks like Input----Surrogatekeystage-----output When running,the job gets aborted with log Could ...

Thanks for you reply. It is running now,but showing one warning as

'Ignoring Duplicate entry at table record 6:nofurther warning will be issued for this table'

Please clarify.