Question
wipro
IN
Last activity: 10 Apr 2024 7:18 EDT
Extract rule DDL Error
In pega 7.2 ,We are implementing Extract rule (BIX) in our organization for data migration by using DataBase schema method.
we have add all properties in the extract rule which we are expecting to extract in which we have same properties in different pages which holds different values. while generating DDL we are getting error that same properties with same name cannot be allowed.
But we want both properties.
Can anyone help us with this issue
Accepted Solution
Updated: 10 Apr 2024 7:17 EDT
Bits in Glass
IN
@rajkotiariga ya that's not possible in extract rule. If you are having same in different pages under the same table, then you need to use map to. You need to map those page properties to map to column. So while generating DDL those will be treated as different column and when it's executed in DB, those map to columns will be created as column.
Maantic Technologies Pvt Ltd
US
Hope you are doing well.
Can you once try to generate DDL for one property at a time. Do for one property first and then try for the other property.
Thanks
Megha
Accepted Solution
Updated: 10 Apr 2024 7:17 EDT
Bits in Glass
IN
@rajkotiariga ya that's not possible in extract rule. If you are having same in different pages under the same table, then you need to use map to. You need to map those page properties to map to column. So while generating DDL those will be treated as different column and when it's executed in DB, those map to columns will be created as column.
wipro
IN