Problem Summary:How to create channel for 500+ tables and set PK and DK for all tables with approx 250 columns in each tables
Answer:
We can accomplish this need using a command line utility named hvradapt.
It sounds like you are already familiar with using the Table Explore feature via the Console (GUI) to define which tables are included in the replication channel definition. You are then clicking on the properties to manage the replication or distribution keys. As you noticed, Local Data Processing was already setting the PK based on the tables primary key or unique index. If you want a command line equivalent, then hvradapt is the command utility to use.
In short, create an input file that lists all of the tables to include. You probably want to add a "+" to the top line indicating to add tables to channel. When you create the list of table names, add the -K (column list) after the table name to declare which columns to use for the distribution key.
You can find examples of a sample input file and example running the command in the following wiki page: https://www.hvr-software.com/docs/commands/hvradapt