DSXchange

FABS(). I just stumbled upon this funtion that takes a float as input and calculates the absolute values of the number. I tried with an example and it works good for me.

Maybe Kiran can try this.

Thanks,
Shekar

Nope, you cannot use a link partitioner to achieve this. You can achieve this through a transformer, by using constraints.

Thanks,
Shekar

Then there is definitely something wrong, in the manner in which you are creating the hash file or referencing it. Please write the contents of the hash file to a seq. file and see how many records the seq. file contains.

Thanks,
Shekar

Hi Harithay, Please try by getting the code to the bare minimum. In the job 3 and job 4 don't use the pivot stage. write the output to a temporary seq. file, and see if it is getting the right surrogates. hashfile | | seqfle------------>transformer------>seqfile see if it is getting the right surrog...

Hi Bappaju,
Please refer to the following link. It has answers to almost all your questions.
viewtopic.php?t=85364.[url]

there are 27142 records in source, i have same number of records going to hashed file. when i run the job i am getting only 178 records on hashed file reference link to the transformer. . the job finished succesfully but not loading surrogate key to the out put. Are you getting this statistics, fro...

Hi Kiran, The DataStage documentation specifies that the input argument to the abs function should be of type int32 and return type is a dfloat . But in that case even your +ve number have to be truncated. I tried it with an example and have noticed that the decimal part of my positive numbers are t...

I assume you are using an upsert mode in the current job and hence cannot identify the rows that you are inserting/updating. One option is, you can seperate the inserts and updates. Once seperated you can have two jobs, one that inserts and another that updates. This will allow you to use the GetLin...

Hi Harithay, You can do it by creating 4 seperate jobs. JOb 1) first i am loading parent table with 5 columns mappping from source , with surrogate key generation. sequnce is generated in sql server data base . src------>transfomer-------->target1 Job2) Create a hash file of the first target with th...

Hi Harithay, You can do it by creating 4 seperate jobs. JOb 1) first i am loading parent table with 5 columns mappping from source , with surrogate key generation. sequnce is generated in sql server data base . src------>transfomer-------->target1 Job2) Create a hash file of the first target with th...

I don't see any reason why it should not.

Thanks

HI Bapajju There has been a lot of discussion in the forum regarding hash file performance. You will find a lot of valuable information if you search this forum. However to answer your question What is the value of modulus you are specifying when the hash file is created. You need to use a modulus s...

If you are getting a null then maybe, you should set it to 0 and add it to the @INROWNUM ??

Thanks

Hi Hari,

I have experienced this error and in my case it was because of Kerberos Authentication. Contact your admin and see if you have your kerberos account set up?

HTH

Thanks

Hi Vj

I may be reiterating what siva has already said, but this is what you can try for the example data that you posted that you need to read.
Go to the properties tab of the sequential file and add the property default null field value and put in ''(two single quotes) as the value.

HTH

Thanks