DSXchange

Solved it. Main reason why the error occured. As loveojha2 suggested, the keys are not the same. I thought I checked the Key property for the output column in the Link Collector but it was the Group property that I checked. Also, in my testing, whilst trying to make all the keys the same, I cannot d...

Things I have tried: 1) I have tried removing the other database stage to see whether it will fix the problem but it does not. 2) By the way, my hashfile output to the link collector does not have the same keys, only has the same columns. I have also tried making the keys the same but it does not so...

Hi, I have two links going into a Link Collector and output to a Sequential file. One of the input links is from a database stage and the other is from a hashfile. The strange thing is that everything fromt the database stage gets through without a problem but the one from the hashfile is filled wit...

Yes, the two links go to the same hashfile. But the links are not coming from the same transformer but each comes from their own respective database stage. I can't guarantee that which will come first though. My impression now having heard your comments is that my best bet will be to write a User De...

I have two input links to the hashfile stage. I set one of the links's settings to "Create File" & "Clear File before Writing". It occured to me that if I set the 2nd link to have the same settings, the "Clear File" setting will cause each other contents to be delet...

Fascinating, the ways to get round these issues. Thank you. :D

I don't under the @FALSE constraint. Will it set the link to never be processed and therefore no values will be written into the hashfile but yet the hashfile will still be created?

I have a transformer stage which uses a hashfile for lookup purposes. The contents of the hashfile is written by the transformer itself. Everytime I have new contents, I write it to the hashfile and later will do a lookup to see if the contents already exist so I won't let these duplicates through. ...

I realised that for what I am doing I must save the below concat lines "EuropeSource.txt - Role : Manag, Phone: null, Email: null" "EuropeSource.txt - Email: null, Address: null" "NAmericaSource.txt - Role : Manag, Address: null" into a reason column due to requirements...

Doing each test in its own stage will work I think, I will probably write to a hash file so all repeated items will overwrite itself.

Are there anydisadvantages I should note if I do it this way instead of bunching all the checks within one transformer stage?

I have some lookups and checks I want to do on data from a flat file. For example: Name | Role | Phone | Email | Address John | Manag | null | null | null | When I put the above row through the transformer , I will do a check on the Role, Phone, Email and Address columns. Since the Role is spelt wro...

Sorry to mention about use @OUTROWNUM=1 in constarints for delete link yes ...Just type user-Defined SQL Make Time_ID as key in column tab .... It will take "?" The @OUTROWNUM=1 was really crucial. Strange thing is that my User Defined SQL doesn't work with the "?", I had to use...

Does this mean I just type in the SQL>User-Defined tab the DELETE statement? DELETE FROM <MyTargetTable> WHERE TIME_ID = ? Just ran it and there are errors. Will the database stage (my target stage) understand that the '?' is refering to TIME_ID column in target stage? Hi, No need of writing delete ...

Neat!

I can't wait to try it. :D

I need to delete all records which has a time key (part of a Compound Primary Key). 1) The user entered date is stored as a stage variable and through a routine, it is changed to a certain YYYYMMDD format to be used as a time key. 2) The deletion of the records apply only before I need to insert new...