on 06-18-2016 4:51 AM
Hi Moumita,
Remove PRODID from Generated key column in TC and also remove PRODID from compare columns lits and run the job and check.
Thanks,
Ravi kiran.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All
Thanks a lot for all your help and additional information sharing.I got the output, the thing which I did not notice initially was that my table transform was actually working. My Datasource had little incorrect data( the ProdID ) fields were repeated, due to which the existing (updated records or newly added records with duplicated ProdId were getting replaced with the existing records and were placed alphabetically ,which I did not notice before).Accordingly I made the changes in the source data and checked out the steps and information mentioned here.
Now everything is working
Thanks
Regards
Moumita
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Table comparison basically flags the input data set into different opcodes-insert,update,normal and delete.In your case, the last 3 rows have to be mapped as insert which is not being done meaning comparison is not happening.
Having PRODID as primary key, make sure you don't have other records with same PRODID 1071,1081,1091 in your Current Table. If they are already present in current table, then they might have got updated.
Next remove the PRODID in the compare field and generated key column of table comparison.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Moumita,
You have PRODID as the Generated Key and also ProdID in the compare columns. Are they both the same ?
Can you please elaborate the issue. I understand that at source there are 24 records and at target you get only 21 records corresponding to source.
Thanks,
AJ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Moumita,
If I have got your requirements clearly, you are going to insert a record if not present in the target and update the same in the target when an update is received at the source.
The conditions on which Insert/Update happens is the Primary Key that drives the table comparison.
As PRODID is you Generated Key Column, unless you have multiple rows wih identical primary keys and unique PRODIDs, you should not be using the PRODID as the "Input Primary Key Column".
Because this here acts as another key generated for the table at target(Surrogate Key).
Instead, you must use a primary key of the table, my best guess is the CustID as the "Input Primary Key Column".
And then pull all the other columns in the "Compare Column" fields on the basis of which comparisons will be done.
Hope this helps.
Please try out this scenario and let me know.
Thanks,
AJ
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.