primary key in dynamic schema

Six Stars

primary key in dynamic schema

hi,

             in excel file there are 5 columns in that center one(3rd column)  is my primary key.

if i want to send the datas to DATABASE using dynamic schema, how can i do this

note: the position of primary key should not be changed , it should be at center

i can able to do this job with primary key at last position and first position, but i want to know how to do this when my primary key at the center position

Six Stars

Re: primary key in dynamic schema

Hi,

 

You just have to tick the key checkbox for which so ever you want to specify as a primary key even though if it is dynamic schema, refer the pic .You can keep the previous one too i.e rollno, and it reflects at the same position only.solutionMidPrimary.png

Six Stars

Re: primary key in dynamic schema

hi

      thanks for the reply, but here, in your image all the column are in different datatypes like int, string but i want the left side of the tmap have one column and it should be of dynamic type 

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download