Search found 15 matches
- Tue Mar 08, 2016 10:31 am
- Forum: IBM QualityStage
- Topic: Does AVI populate any Time Zone information in output field?
- Replies: 13
- Views: 11517
- Thu Mar 03, 2016 10:00 am
- Forum: IBM QualityStage
- Topic: Does AVI populate any Time Zone information in output field?
- Replies: 13
- Views: 11517
- Tue Mar 01, 2016 9:24 pm
- Forum: IBM QualityStage
- Topic: Does AVI populate any Time Zone information in output field?
- Replies: 13
- Views: 11517
- Thu Feb 18, 2016 10:20 pm
- Forum: IBM QualityStage
- Topic: Does AVI populate any Time Zone information in output field?
- Replies: 13
- Views: 11517
Thanks for your help. I need little more help from you..... #\* | ** ; The last asterisk, followed by anything, eg: *** USE ABC # 123 *** NEW YORK COPY_S [1] {OutData} ;NOTE: Normally this would be [2], but this is a workaround because of the #\* RETYPE [1] 0 ;NOTE: Normally this would be [2], but t...
- Fri Feb 12, 2016 10:23 pm
- Forum: IBM QualityStage
- Topic: Does AVI populate any Time Zone information in output field?
- Replies: 13
- Views: 11517
- Fri Feb 12, 2016 2:03 pm
- Forum: IBM QualityStage
- Topic: Does AVI populate any Time Zone information in output field?
- Replies: 13
- Views: 11517
Thanks Ray and RJDickson!! I would have another question.....do you know if there in any pattern action code I can add to USNAME.PAT file to get the string after the * (Asterisk)? For Instance.... *** USE ABC # 123 *** NEW YORK I like to store the information after last asterisk (i.e. NEW YORK) in A...
- Thu Feb 11, 2016 6:20 am
- Forum: IBM QualityStage
- Topic: Does AVI populate any Time Zone information in output field?
- Replies: 13
- Views: 11517
Does AVI populate any Time Zone information in output field?
I am creating a job to clean addresses and then conform to USPS Postal Standard. Can I use AVI to cleanse and correct data to Postal Standard?
Also - can we get output fields from AVI with time zone (i.e. Eastern, Central, UTC/GMT) information?
Thanks in advance.
Also - can we get output fields from AVI with time zone (i.e. Eastern, Central, UTC/GMT) information?
Thanks in advance.
- Mon Jun 01, 2015 10:50 am
- Forum: General
- Topic: Calculating Distance between Latitude/Longitude points
- Replies: 8
- Views: 11297
- Mon Jun 01, 2015 7:46 am
- Forum: General
- Topic: Calculating Distance between Latitude/Longitude points
- Replies: 8
- Views: 11297
Calculating Distance between Latitude/Longitude points
Hello All,
I am trying to figure out how to calculate distance between Latitude/Longitude points. I am not sure if there is any built in functions in transformer stage I can use. Please advise. Thanks!!
I am trying to figure out how to calculate distance between Latitude/Longitude points. I am not sure if there is any built in functions in transformer stage I can use. Please advise. Thanks!!
- Fri Jul 06, 2012 9:50 am
- Forum: IBM QualityStage
- Topic: # is not converting to UNIT after ran through AVI Stage
- Replies: 4
- Views: 5026
Thanks a lot for your response!!! I am actually trying to see if AVI Stage is capable of being configured such a way that once it receives # it should convert automatically change to UNIT for that particular address. If you know any configuration changes that can make it happen please let me know. F...
- Thu Jul 05, 2012 2:00 pm
- Forum: IBM QualityStage
- Topic: # is not converting to UNIT after ran through AVI Stage
- Replies: 4
- Views: 5026
# is not converting to UNIT after ran through AVI Stage
I have the following for the address: AddressLineOne: 4999 BONITA BAY BLVD #1801 AddressLineTwo: AddressLineThree: City: BONITA SPRINGS ProvinceStateType: FL CountryType: USA I am expcting the address should be coming out after ran throuh AVI Stage is: 4999 BONITA BAY BLVD UNIT 1801 I have the patte...
- Fri Jun 03, 2011 9:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Having issues with Lookup Stage
- Replies: 7
- Views: 5289
- Wed Jun 01, 2011 10:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Having issues with Lookup Stage
- Replies: 7
- Views: 5289
- Tue May 31, 2011 1:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Having issues with Lookup Stage
- Replies: 7
- Views: 5289
My 'Lookup Failed' rule is setup as given below: Condition Not Met --> Fail and Lookup Failur --> Fail Can you please suggest how to fix this error that I get while running: Lkp_Add_Updttm: Error occurred during initializeFromArgs(). Lkp_Add_Updttm: When processing argument -ifNotFoundWhen processin...
- Fri May 27, 2011 9:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Having issues with Lookup Stage
- Replies: 7
- Views: 5289
Having issues with Lookup Stage
Hi All, I am having some issues with Lookup Stage. I have one dataset as source and another one as reference connected to lookup stage and then connected to a transformer stage to find the required records that will be loaded to Oracle table. While running I get the following error: Lkp_Add_Updttm: ...