DSXchange

Earlier I used Db2/UDB API stage for connecting the DB2 but that seems to be more confusing and I came to know through the forums that DB2 enterprise is quite easy compared to API. I gave server name,username,password for API. can any one suggest me how to use DB2 enterprise. In the output tab I hav...

That works!!


Thank you ALL!!

When I use a stage variable as suggested svreject=...........

use that stage variable as constraint
something like

svreject =true in the contraint of that output.

Is this right?

I removed all the duplicates by using remove _duplicates stage so the field person_name has only one row which has null and that is the key which I used in remove duplicates. For the safe side I will use the stage variable svRejectFlag. In this stage variable IsNull(in.col1) or IsNull(in.col2)...cno...

Transformer constraint There are 5 fields( 4 char,1 integer) the 4 fields has null in that records and the other interger field has "0". IsNotNull(dslink.Person_name) where Person_name is one of the 4 fields. can I use the above function in the transformer constraint to reject the single r...

A job is designed to load data into a table. These records are unique records so before loading into the table remove_duplicates stage is used to remove the duplicates. Finally all the records without the duplicates are loaded,one record among them has all fields null except a field which is "0...

In the documentation given by IBM along with the tool I did not find the CASS stage document in quality stage guide. Some of the addresses entered return with the zip code with addition of 4 but none of the entered wrong address is not giving the response as the correct address. I changed the dataty...

Actually first I designed a service using only CASS stage,i.e only to correct the address. so when I test his service with soap UI tool the request which I sent is <addr_line1>1800 holand dr</addr_line1> <city>somerset</city> <state>NJ</state> <zip>08873</zip> and the response I received is <addr_li...

Thanks for the Information. In the job I used CASS stage for correcting the address,So is it something when the input is any address the output will be a correct address. Coming to standardized stage,After using the CASS stage the next stage I use is standardize stage to standardize the correct addr...

Thanks Istsaur

So ignore them or fill them with anything........doesn't matter right?

That worked.....used trim to the records from the table and trim to the records from the file and now the lookup works.....well.

Thanks for all valuable inputs!!

Actually these fields were filled in the previous jobs designed by other developer.

do you think I also need to fill them,If they are related to discount from USPS?

Thanks,

asked the admin and got the current database files which are used for the reference. so when I use CASS stage to correct the address the input from a file should be addr1,addr2,addr3,city,state,zip In the properties of CASS stage there is a folder form3553 under this folder there are 3 fields to be ...

there are some nulls but removed the nulls from the primary key column. probably I need to change the column because when the records come in required way then nulls can be removed and change to values. before this stage of removing nulls a lookup is done between a table and a file. table as a prima...

the earlier one worked when the datatype is changed. but now I see another waring which drops many records all the duplicate records,used a look up with continue also with duplicates...but I get the below kind of warnings DB2_UDB_API_77,0: Warning: DSproject2.DB2_UDB_API_77: [IBM][CLI Driver][DB2/SU...