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

DI Studio -- How To?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 8
Accepted Solution

DI Studio -- How To?

I have three questions:

1. Can a Table Loader Transformation have more than one input?

     Can we connect it to two data sources or do we always have to connect the two data sources to a SQL Join transformation and output of that is         connected to the Loader.

2. How do we delete rows in a target table?

3. How can I get max/min values of some columns along with class/by variables ?

Regards,

Jagtar Cheema


Accepted Solutions
Solution
‎12-12-2011 02:40 AM
Super User
Posts: 5,434

DI Studio -- How To?

  1. No. If you want to load data from more than one source in the same step, use SQL Join or Append transformations as input to a table Loader. If you want to load data from multiple sources independently you can add more Table Loaders to the job, or creating multiple jobs.
  2. If you need to delete all rows in the target table, it is an option in the tabel laoder transform. If you want to delete rows in target based on the input, there are some options in the update/insert scenario you can use. If you want to delete rows using other scenarios, you might want to write your own "delete from" code in a User Written Code, or as a pre step in the table loader transform.
  3. There are several ways, and the best way depends on what you are going to to with the result. You can user the Extract or SQL Join transforms to create min/max analysis with GROUP BY.

Br

Linus

Data never sleeps

View solution in original post


All Replies
Solution
‎12-12-2011 02:40 AM
Super User
Posts: 5,434

DI Studio -- How To?

  1. No. If you want to load data from more than one source in the same step, use SQL Join or Append transformations as input to a table Loader. If you want to load data from multiple sources independently you can add more Table Loaders to the job, or creating multiple jobs.
  2. If you need to delete all rows in the target table, it is an option in the tabel laoder transform. If you want to delete rows in target based on the input, there are some options in the update/insert scenario you can use. If you want to delete rows using other scenarios, you might want to write your own "delete from" code in a User Written Code, or as a pre step in the table loader transform.
  3. There are several ways, and the best way depends on what you are going to to with the result. You can user the Extract or SQL Join transforms to create min/max analysis with GROUP BY.

Br

Linus

Data never sleeps
Occasional Contributor
Posts: 8

DI Studio -- How To?

Thanks.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 906 views
  • 0 likes
  • 2 in conversation