DSXchange

i dont think till now we have any such utility to read ebsidic file.

Please share more informaiton if any one find such utility

use left outer join and get all the records to filter stage and filter out all records which has null value in any of the field which is coming form reference link (i mea right link)

use join stage rather than lookup stage. sure it would reslove your problem

read the data form both the input links and add column genereator stage in each input link to create unique sequence number in new dummly key column which can be defined in the column generator stage (edit column metadata and provide "part" as start value and "partcount" as incre...

Thanks Craig, I think, The first option of Usage Analysis doesn't give the informaiton about the field/metadata. I am trying the second option, but it is taking lot of time and it manual work which currently i am doing. Please let me know if you have come accross this type of problem before and how ...

Hi All, I have to do some amendment in a field which is being used by datastage jobs in a project. I have 1000s of datastage jobs in my project. I need to findout the impected datastage jobs which are using that fields. Can any one please let me know if we have any utility/ program by which we can d...

Thanks Ray,

fork join design is working. i just wanted to know, is this design optmized to achive the outcome ?

Hi I need to count source records using key fields and attched this count to all record in output. I want to keep all source records and fields in target with record count based on key field. Exmple: Source data Key Col2 Col3 1 A X 1 B Y 2 C Z 3 D S 3 D Y output Key Col2 Col3 Count 1 A X 2 1 B Y 2 2...

Hi ,

do we have any utility to view data from LookupFileSet stage.

thanks

If yuo are using oracle enterprise stage, you can use NVL fucntion to handle null.

If you are using sequential stage to read ascii file you can handle them at column level . edit the column and provide NULL value and that will be replaced if found any null.

you can go throuh datastage parallel job developer guide.

it can give you more detail on each of these stages.

Hi I have done some workaround to resolve this issue. Now I am directly putting job parameters in side the stored procedure stage in Procedure call Syntax box instead of passing from transformer. I am passing only one field from transformer stage, and rest of the fields from job parameters. For exam...

Try the following 1.) Make the length as 10 and re-run 2.) Change the stored procedure to take 2 parameters. Set one to be hardcoded and next from the link variable. ... when i am specifying the length 10 for message field. I am getting below ewarning message followed by error message. warning mess...

The database has a defined length, and may be objecting to metadata suggesting that the string may have a potentially larger (that is, unlimited) size. ... In this situation, what length should i define in DataStage table definition? currently i am using varchar2 in both datastage and database with...

Now you know the source of the error and may more closely focus your diagnostic efforts. Check whether there is a metadata mismatch; the stored procedure stage does not report these. ... Hi Ray, I dont have any datatype mismatch. in addition to this, i dont have any defined length for this varcher ...