DSXchange

Hi All... is there any solution for this ???

thanks
MJ

Hi all...

any help on this .... thanks MJ

sorry if my explanation was not clear, now i have edited my post, hope it helps.. a number has to be generated for every unique value that comes in based on a particular, this is one of the requirement i need to handle, i dont want to create a seperate job for doing this functionality alone.. becaus...

Hi Before posting this, i tried myself and searched a lot but couldnt find a solution. my scenario is, Using an SQL i'm retriving around 80 columns and passing it to a transformer, in the transformer i need to assign a number in incremental order for every unique record that comes in based on a part...

Hi In the transformer i'm replacing the New Line with "
" but in the dataset i'm seeing the output as just "&", is there anyway to get the value as it is Input ------- value1( New Line) value2 present output ----------------- value&value2 expected output ---------...

Hi
I'm trying to add some parameters to the environment variables, so that they
can be specified in the jobs, is there any best practice to say that these kind of better to added in the environment variables.

thanks
MJ

8GB RAM

In the drive the Datastage client is installed, around 100GB free space is available

you are the MAN... :D


absolutely.. did it... thanks a lot..

MJ

Hi i'm using the xml output stage to generate the xml, i have created everything, but as a last minute change the downstream needs a small change in one of the column name, as of now the column name is like <columnname>121212</columnname> now they want it as <columnname name="something">12...

thanks a lot for your input craig and ernie...

in a day or two i will post, how i fixed it.. thanks a lot

even disabling doesn't make any difference....

anything happens after we compile or run the job??? that cause the slow down

Hi Now i'm finding a pattern when it gets slow --when i initially open the designer and start opening a old job or creating new jobs... its normal.. Once i compile a job or ran a job after that it goes terribly slow, even if i want to open a transformer or any stage, it takes too much time. then if ...

Hi After few more tests, I changed the lookup failure option to "fail", now the lookup is failing, may be thats why the data gone past the lookup, in the director log i'm having warnings for that key column i'm using to join the nodes, the warning is When binding input interface field &quo...

Hi regarding this issue, i have created all the individual nodes/chunks of the xml file, after that using lookup i'm joining the data elements and sending it to the xml file, what's happening in the final xml document that is getting created is, "only the first data element is received for all ...