SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

dfPower Best Practices

Reply
SAS Employee
Posts: 3

dfPower Best Practices

Does anyone out there have some good sources for dfPower best practices? How would you approach your first data cleansing project?
Cheers,
Barb
SAS Employee
Posts: 38

Re: dfPower Best Practices

There are lots of resources on the dataflux website: www.dataflux.com. Checkout the knowledge center. Another option is to pick up a copy of the "The Data Asset - How Smart Companies Govern their Data for Business Success" by Tony Fisher. You can get a copy from Amazon, and I believe the SAS internal library would also have several copies. It is an excellent primer on best practices for data quality and data management, and includes some good case studies.
SAS Employee
Posts: 3

Re: dfPower Best Practices

I will definitely send the customers to the DF website, I was hoping to find out wonderful websites, etc....
New Contributor
Posts: 4

Re: dfPower Best Practices

Could you please provide more sample examples of how to do a schemas and QKB..etc by using Dfstudio.
SAS Employee
Posts: 1

Re: dfPower Best Practices

Jo,

If you open the HTML dfPower Studio User's Guide and type "scheme" in the Search panel, you will get a list of topics that explain how to create and use scheme files.

If you are looking for something specific that is not included in those topics, can you explain what it is? Then maybe we can provide additional information.
New Contributor
Posts: 4

Re: dfPower Best Practices

Posted in reply to brineer_sas
Hi Brineer,

Thanks for your response.

Could you please provide more information about below questions.

1.how to read external data (excel , csv,txt etc). in df studio
2.how to register qkb and how to use
3.how can we create reports and i need to create scheem on the same report
4.how to create architech & profile jobs, if possible could you please provide examples
5. how to plug the df jobs into sas di

Thanks inadvance.
SAS Employee
Posts: 75

Re: dfPower Best Practices

Jo,

To read external files, see the DI Studio User Guide chapter "Working with External Files" : http://support.sas.com/documentation/cdl/en/etlug/62233/HTML/default/p0rhnqjrb6tje9n1jyfk9h4kn386.ht...

For all DI Studio doc related to DataFlux data quality . . . display the help in DI Studio, click the Search tab and search for "Working with Data Quality Transformations."

For the creation of architech & profile jobs in dfPower Studio -- see dfPower Studio documentation.

For how to reference df jobs into sas di -- see "Working with Data Quality Transformations" above.
SAS Employee
Posts: 38

Re: dfPower Best Practices

Here is another good site: www.dataroundtable.com
Ask a Question
Discussion stats
  • 7 replies
  • 347 views
  • 0 likes
  • 5 in conversation