Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to set Qlik replicate to map an existing table for a new CDC source table. how does it behave when the to be mapped table or column names are slightly different
Regards
Fazil M
Hello Fazil M, @MdFazil
I think you are talking about 2 different questions.
1- How to map the columns between source and target tables
2- How to map the source table and target table especially if the target table contains some data
Well, for Question 1, you may change the column name in the table settings. In below sample we overwrite the column name to LOCATION, so far we map the source column ADDRESS to column LOCATION in target.
Q2, we may rename the target table in table settings level , or global level, For example in table level, the source table SCOTT.TESTDDL map to target side DBO.FINALDDL.
If the target side table contains existing data and you want to keep it, there are some options for the Target Table Preparation in task settings.
Hope this helps.
John.
Hi @MdFazil
I think you are asking how to map a source table to an existing target table to capture changes.
Just like what @john_wang instructed, map the source table to your existing table by giving the exact target schema name and table name, then in Transform tab, make sure to rename the column to match the column name of your exiting target table. You can also just select the columns you need, for example, you have 5 columns in source, you can just select 3 and rename them to match your target table column name.
Thanks
Kent
Hello Fazil M, @MdFazil
I think you are talking about 2 different questions.
1- How to map the columns between source and target tables
2- How to map the source table and target table especially if the target table contains some data
Well, for Question 1, you may change the column name in the table settings. In below sample we overwrite the column name to LOCATION, so far we map the source column ADDRESS to column LOCATION in target.
Q2, we may rename the target table in table settings level , or global level, For example in table level, the source table SCOTT.TESTDDL map to target side DBO.FINALDDL.
If the target side table contains existing data and you want to keep it, there are some options for the Target Table Preparation in task settings.
Hope this helps.
John.
Hi @MdFazil
I think you are asking how to map a source table to an existing target table to capture changes.
Just like what @john_wang instructed, map the source table to your existing table by giving the exact target schema name and table name, then in Transform tab, make sure to rename the column to match the column name of your exiting target table. You can also just select the columns you need, for example, you have 5 columns in source, you can just select 3 and rename them to match your target table column name.
Thanks
Kent
Hello @john_wang ,
thank you for the reply,
question 2 is what I want to ask, and thank you for the clarification. I have One more doubt regarding this. how does it behave when the source table or column names are slightly different. Thanks
Regards,
Fazil M
Hello @Kent_Feng ,
Thank yo for the reply,
You are right, and that is what I want to know. Thank you for the clarification
Regards
Fazil M
Hello @MdFazil ,
Thanks for the feedback. Qlik Replicate supports the object identifier (table name, column name, PK or Unique Index name etc) mapping. The object identifier difference is not a challenge in Qlik Replicate and it's pretty easy to implement. Feel free to let us know if you need any additional information.
Regards,
John.
Hi @john_wang , Thank you for the reply.
I got clarified, Thank you
Regards
Fazil M
Thank you so much for your support @MdFazil !