DSXchange

Right click on the hashed file and view the values of the output link to see if you can see the values in the hashed file. If you used a local container, make sure the links at both ends of the container are identical. Hope this helps. shepli I can able to view the data both on input as well as in ...

Check closer. Lookup failures simply mean you did not get an equality match on the values. Period. So, for whatever reason, your values are not matching. Do a View Data on both the source and lookup source, and click inside the Key fields on both sides. Move your cursor around inside each field. Th...

Probably you are doing the lookup in a transformer stage where you have the main link coming from the sequential file and the reference from the hash file stage. You might be updating the hash file somewhere first from a database stage probably ODBC. so in reference link remove the hash file and di...

I am using a flatfile so in server i have to use a hash file to do look up.

Hi everyone, I have checked my key fields data whether there might be a trimming issue or spaces or might be a null, but i think there is no such issues in my key fields data.i have taken two fields as keys and tried to compare with my source data through the transformer so i can able to see the row...

Hi everyone ,

i recheked again .i had defined the Keys properly but still getting the same error. The same 0 rows are showing.

Thanks in advance

Hi everyone , I have an issue regarding the Hash file.i am using hash file as a look up and trying to do some transformations with my source to get the output.everything is executing as it is showing a green line but the link from hash to transformer is showing a green line but with 0 rows.i can abl...

Thanks for the reply craig.

I have one more thing to clarify.every time the new data comes in the production.here my question is whatever the data comes from the source that has to be loaded in the target and now i need to check whether all the records which are in the source have been loaded into the target or not by doing so...

Explain to us what controls the 'number of tables' you'll be targeting or processing? Perhaps that might help people towards a solution. Also, do these tables have identical metadata? I had created a job with two sources i.e. s1 and s2 and I need to check for each record of s1 and s2 is matching or...

I need a generalized solution say for suppose today if they are executing for 10 tables, may be tomorrow they might execute 20 tables .so i cant create a sequence every time if the number of tables changes .so i need a genralized one so that if i want to execute 20 tables i can able to execute witho...

A sequence containing ten job activities with explicit error handling from each, collecting through a sequencer into final error handling. ... In this case , we know that it is 10 tables but if it is more than 10 tables in another scenario , then we cant create 100 jobs for 100 tables , so i want t...

Hi every one , can any one tell me he proces of how to insert multiple tables at a time and i need to run all the tables say for suppose if we have 10 tables .i need to run all the tables at a time i mean one after other and if i find any error in any table it should not stop executing untill it is ...

my code is

i had taken rowcount as a seperate column and initialized to 1
then i had written
crc32(Nulltoempty(comcode):nulltoempty(procode))=stagevar1
if stagevar1=stagevar2 then rowcount+1 else 1=stagvar
crc32(Nulltoempty(comcode):nulltoempty(procode))=stagevar2

I dont have a clear understanding on your approach but If i'm doing this I will try something like this: Sort rows using company code and product code. Assign the initial values for all stage variables as empty ( '' ) svOldComp = svNewComp svNewComp = Link1.CompCd Column svOldPrd = svNewPrd svNewPr...