Template tables and HANA

dataservices job design
1

I loaded data into HANA using a template table. It appears that this creates a row table instead of a column table, which was what I expected.
Does Data Services always create template tables as row tables? Or can this be changed at some point?

lamanp :netherlands: (BOB member since 2008-09-02)

2

what is the DS version, there is option in template table to select if Column Store or Row Store

I tried in DS 4.0 SP 2 Patch 5

manoj_d (BOB member since 2009-01-02)

3

Guess I had the wrong ‘Database type’ in my datastore. ODBC instead of HANA. I now see the option to choose between row and column store.

Thanks.

lamanp :netherlands: (BOB member since 2008-09-02)