DSXchange

Thanks

I got it (unlocking the job) from drector----->job------->Cleanup resources.

hi all, i have problem in lookup. i have to load two tables from one input table. the tables posses referential integrity . i loaded table 1 succesfully to sql server database, in which primary key for the table(surrogate key) is generated automatically. I need to load Table2 from input where primar...

Hi all,

I am unable to open my job, whe i tried to open, it is giving following message.

'Job Basel_Nav is being accessed by another user'

Hi shekar; I did writing to sequentail file , input to sequential contains 27142 records. the output of Hashfilestage (input to sequential file) ( if i check the 5 key columns) , so i think there is no problem in hashfile creation ryt? Then there is definitely something wrong, in the manner in which...

Hi shekar; Even i tried that way also. by connecting temporary sequential file. in that case also i am getting 178 records on reference link out of 27000 records. in this case also i am not getting surogate key on to the output link . in the output , it is giving just blank. Thanks Hi Harithay, Plea...

yes shekar, the combination of all 5 columns is unique. 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 k...

hi shekar, yes the combination of all 5 columns is unique. what might be the mistake ="dsdesigner"] Are you getting this statistics, from the designers "view link statistics". Are the five columns unique across all the 27142 rows? Even though you see 27142 records going to the ha...

Hi sainath ;

I did not get you.
the meta data is perfect in both source and and refence link.

can u please explain in detail.

Hi shekar, exactly i am doing same way. but my look up is not working properly. my source is same for job1(parent table) , job3( 7 columns, pivot)), job4( 8 columns- pivot) . yes, i loaded surrogate key, composite key 5 columns (natural key) , matching key columns in hashed file. in transforemr i ha...

Hi all, i am loading from flat file to three tables. target database is sql server; i have 20 columns in source file. first i am loading parent table with 5 columns mappping from source , with surrogate key generation. sequnce is generated in sql server data base . i need to load other two tables se...

Thank you very much Kris and Ray . i got it through 'Ray's suggetsion . By taking extra columns as the same number of column headers what i am pivoting . hard coding column headers into these extracolumns in transformer. after that pivoting both using pivot stage. Hope you understood the logic....wa...

Hi kris, thanks for ur reply i did not get you , what i am doing in pivot stage output is as follows pivot/ output tab/column tab ; i am writing coumn names manually ID VALUE SAR-A,SAR-B,SAR-C,SAR-D (in derivation field of VALUE) is it possible to get corresponding column name for its coreesponding ...

hi ray , is it possible to get column names autoamaticaly (without writing their names manualy from keyboard)?? In a Pivot stage, there is no legal way. Unless you know how to extract column names from the metadata in the Repository, there is no available mechanism. column names are loaded manually ...

Hi all i need to convert columns in to rows , for that i am using pivot stage but my requirement is to write column headers for corrsepong values. EXAMPLE; i have 5 columns (INPUT) ID, SAR-A, SAR-B, SAR-C, SAR-D 1 0.0 0.0 1.0 10.0 2 1.0 2.0 4.0 5.0 required output should look like this ID SAR_ID VAL...

hi ray, sainath

ray.wurlod wrote:I have grave doubts that a Routine is what you want. From your - albeit incomplete - specification, I'd suggest an approach that sorts the input file then performs change detection via stage variables is more appropriate.

thanks for ur suggetions. i got it

Best Regards