DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
kennyapril
Participant



Joined: 30 Jul 2010
Posts: 248

Points: 2118

Post Posted: Tue Mar 01, 2011 11:26 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
I have to design a job in which the source contains 1 million of addresses and the target should be the validated addresses from the source.

For this validation

source----->cass----->standardization----->target

or
Source------>standardization--------->cass------->target

please let me know which should be followed in the above ways or any suggestions!!

_________________
Regards,
Kenny
jaksani
Participant



Joined: 01 Mar 2011
Posts: 48
Location: Hyderabad
Points: 344

Post Posted: Wed Mar 02, 2011 6:00 am Reply with quote    Back to top    

Second step
Source------>standardization--------->cass------->target
is correct.

_________________
Thanks & Regards,
Venkat Jaksani
Rate this response:  
Not yet rated
kennyapril
Participant



Joined: 30 Jul 2010
Posts: 248

Points: 2118

Post Posted: Wed Mar 16, 2011 12:11 pm Reply with quote    Back to top    

Thanks for the information!!

CASS does the standardization of address and If the input has a name then name should be standardized with standardize stage.

If the case is the input has only address1,address2,city,state,zip
Do I need standardize stage or Just the CASS stage?


any info please?

_________________
Regards,
Kenny
Rate this response:  
Not yet rated
lstsaur
Participant



Joined: 21 Oct 2004
Posts: 1136

Points: 5414

Post Posted: Wed Mar 16, 2011 12:48 pm Reply with quote    Back to top    

CASS stage only. Also study the tutorial job for CASS under the installation folder. Its input source, Excel spread sheet, has exactly the fileds that you specified.
Rate this response:  
Not yet rated
kennyapril
Participant



Joined: 30 Jul 2010
Posts: 248

Points: 2118

Post Posted: Wed Mar 16, 2011 1:10 pm Reply with quote    Back to top    

Thanks Istsaur.

which Installation folder is that?

Is it under documentation?

_________________
Regards,
Kenny
Rate this response:  
Not yet rated
lstsaur
Participant



Joined: 21 Oct 2004
Posts: 1136

Points: 5414

Post Posted: Wed Mar 16, 2011 1:58 pm Reply with quote    Back to top    

No, it's in e.g. C:\is-ia-suite\TutorialData\QualityStage.
Rate this response:  
Not yet rated
kennyapril
Participant



Joined: 30 Jul 2010
Posts: 248

Points: 2118

Post Posted: Wed Mar 16, 2011 2:23 pm Reply with quote    Back to top    

Yes I see a .dsx file in that folder,I imported the same but that tutorial has no CASS job It has only investigate,standardize,survive,unduplicate.


any other info please?

_________________
Regards,
Kenny
Rate this response:  
Not yet rated
lstsaur
Participant



Joined: 21 Oct 2004
Posts: 1136

Points: 5414

Post Posted: Wed Mar 16, 2011 3:06 pm Reply with quote    Back to top    

Sorry, I have been away from QS especially using CASS for too long. As you said in QualityStage folder, it contains all other stages except the CASS stage. That brings back the memory, actually the tutorial job for CASS is contained in the .tar file for CASS.
Rate this response:  
Not yet rated
kennyapril
Participant



Joined: 30 Jul 2010
Posts: 248

Points: 2118

Post Posted: Wed Mar 16, 2011 3:33 pm Reply with quote    Back to top    

Searched all the files but no luck.

I looked into a folder named IS_CASS Files in C:\ but did not find the job.

There are .tar files named CASSDBM1,CASSDBM2...and so on...untared them but cannot see any .dsx file.

_________________
Regards,
Kenny
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours