DSXchange

Hi All, When we try to create hash files , the job is aborting with the following error message : " GSAP_LOOKUP_CreateLkpForRegJobs..XrefSctyOvrdHash.ToBuildSctyOvrdHash: DSD.UVOpen The system cannot move the file to a different disk drive. (17): G:\Ascential\DataStage\Projects\DEV_ZGP0GSAS\mk...

Hi, My job layout Source-> Transformer-> Target. I have 1:1 mapping for maximum columns(from source to target) and for other columns I am passing default value(Empty String for Varchar/Char n 0 for int n dec). Both source and target column length are Proper( In max cases both are same n in some cas...

nick.bond wrote:I'm sure this has been covered before - have a search for it......

Hi Nick,

I searched for it.
But couldnt find much useful information regarding this one..
If you know any specific thread,can you please post that one.

thanks
George

Hi Everyone,

Reference Link with mutli row result set - can anyone tell me how can you set this in server jobs?

Thanks
George

Hi, I know this issue has been talked about a lot. I haven't had to do this since a long time. The issue is range lookups and let me share what I have done so far. MyRefJob ----------- This hashed file job creates a hashed file. Before populating the hashed file, I created the indexes SEPARATELY on...

Hi everyone, I have a scenario The input seq file is having 1000 rows I have 3 output files.I need the output like ... 1st output file should contain (input file rows) 1-10,31-40,61-70 etc 2nd output file should contain (input file rows) 11-20,41-50,71-80 etc 3rd output file should contain (input fi...

Hi Pravin,

I think you need to first sort the data and then use stage variables here as well as the routine rowproc comparewithprevious value.

Thanks
George

Hi Everyone,

Will transfmor work with out an input link?
I know 1 way using stage variable and using constraint
Like @inrownum <1

Heard there are other ways can any one tell me?

Why? A Pivot stage will do exactly what you require. With a hashed file, the technique for a horizontal pivot is to load the non-pivoting columns in a value mark delimited dynamic array and to U ... Sorry Ray, I am not a premium member so i was not able to read your posting fully. Sure i will be a ...

ray.wurlod wrote:And so can you mark the thread as resolved?

Hi Ray,

I dont think i can mark this as resolved since i am not the one who opened the thread.I think MORIS can only do this


Thanks
George

What happened when you ran Exact Match searches for DS.TOOLS and DS.CHECKER ? I got quite a number of hits which answered both questions. Please give that a shot and then let us know if you have any specific questions on either subject. Sorry,It was my fault. When i tried searching both individuall...

Welcome, there are several ways to do that depending on the kind of sourcefile. for example Pivot-Stage or Hash Table or or or .... Start searching in the Forum and if you don't find an answer to your problem, please let us know Hi Wolfgang, By Hash Table do you mean a hash File?If so how can it do...

Hi Prasanna ,

Seems to be a weird error.
Can you open the Director through the designer?

Thanks
George

Hi Everyone,

That really was very informative.Thanks all.This is really a fantasic forum.
I love this.

Thanks
George
:D

Hi Everyone,

That really was very infomative.Thanks all.This is really a fantasic forum.
I love this.

Thanks
George
:D