Greenplum connector only for select columns

dsfamily · Post by **dsfamily** » Wed Aug 20, 2014 9:10 am

How do i use greenplum connector to insert only selected columns.It seems to take all columns by default.

chulett · Post by **chulett** » Wed Aug 20, 2014 9:14 am

According to the documentation it looks like you need to move the columns you want "from the Available columns list to the Selected columns list".

dsfamily · Post by **dsfamily** » Wed Aug 20, 2014 10:00 am

It still looks for all columns

chulett · Post by **chulett** » Wed Aug 20, 2014 10:30 am

Then unless someone has used that Connector here, it would seem you have a Support question. Let us know what you find out.

ray.wurlod · Post by **ray.wurlod** » Wed Aug 20, 2014 4:33 pm

Is runtime column propagation (RCP) enabled on the output link for the upstream stage?

dsfamily · Post by **dsfamily** » Thu Aug 21, 2014 2:07 pm

runtime column propogation is not on.the table is straight select from dataset

ray.wurlod · Post by **ray.wurlod** » Thu Aug 21, 2014 2:34 pm

Check on the Columns tab on the Output link in the Data Set stage. There should be an RCP check box there.

DSXchange