about data matching
about data matching
Hello,
In my project a particular person enters his information in a website and then that website calls a web service I need to connect to that webservice with the help of a stage WISD in data quality in data stage.
As soon as he enters the information that information should be captured and I need to check it with the company database and send a reply that his how much of his given information is matching with the database.
which stages i need to use and what does each one do?
thank you
In my project a particular person enters his information in a website and then that website calls a web service I need to connect to that webservice with the help of a stage WISD in data quality in data stage.
As soon as he enters the information that information should be captured and I need to check it with the company database and send a reply that his how much of his given information is matching with the database.
which stages i need to use and what does each one do?
thank you
-
- Premium Member
- Posts: 138
- Joined: Wed Jul 16, 2008 9:51 pm
- Location: Kolkata
Hi Rahul,
Datastage is an ETL tool and as it is the case with all ETL tools, it is meant specifically for loading data in OLAP systems after extracting data from multiple source systems (OLTPs) where data maybe in different formats after cleansing, transforming the data as per business requirements and validating the data.
As far as I know, though there may be a way to meet your requirements but it is always better to use the right tool for the right job.
Datastage is an ETL tool and as it is the case with all ETL tools, it is meant specifically for loading data in OLAP systems after extracting data from multiple source systems (OLTPs) where data maybe in different formats after cleansing, transforming the data as per business requirements and validating the data.
As far as I know, though there may be a way to meet your requirements but it is always better to use the right tool for the right job.
TONY
ETL Manager
Infotrellis India
"Do what you can, with what you have, from where you are and to the best of your abilities."
ETL Manager
Infotrellis India
"Do what you can, with what you have, from where you are and to the best of your abilities."
data matching
thank you tony
Actually there is a job which is designed as per the requirement and now We need to modify it, so there are some stages in quality stage like match frequency,reference match.......can you tell me which is better for this particular requirement....and can you answer another question please,
Coming to WISD input and WISD output ,how to I connect these to particular web service.....is there any other way to connect to a web service....for a live data..
thank you
Actually there is a job which is designed as per the requirement and now We need to modify it, so there are some stages in quality stage like match frequency,reference match.......can you tell me which is better for this particular requirement....and can you answer another question please,
Coming to WISD input and WISD output ,how to I connect these to particular web service.....is there any other way to connect to a web service....for a live data..
thank you
-
- Premium Member
- Posts: 138
- Joined: Wed Jul 16, 2008 9:51 pm
- Location: Kolkata
Hi Rahul,
For the first part about the stages, It would be better if you can give the existing job design with clear description and the change requirements so that we can work on the modification.
For the second part about WISD stages, I'll look into it and let you know
For the first part about the stages, It would be better if you can give the existing job design with clear description and the change requirements so that we can work on the modification.
For the second part about WISD stages, I'll look into it and let you know
TONY
ETL Manager
Infotrellis India
"Do what you can, with what you have, from where you are and to the best of your abilities."
ETL Manager
Infotrellis India
"Do what you can, with what you have, from where you are and to the best of your abilities."
data matching
sure tony,
I will let you know the design as soon as i get the changes.
Thanks
Rahul
I will let you know the design as soon as i get the changes.
Thanks
Rahul
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: