DI Studio -- How To?

[jcheema]

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

[LinusH · Accepted solution]

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

[jcheema]

Thanks.