1 Reply Latest reply: Nov 5, 2009 2:25 PM by Shumail Hussain RSS

    Link MultiFields

    Shumail Hussain

      Hi,

      I am working on credit card system where i have two main tables. First table (CardMast) contain credit card portfolio and demographics and second table (Card_TXN) contains credit card transaction.

      I have join these tables with credit card no (field name CARD_NO) but i am facing issues with card transaction table. In Card TXN table the card no field is a conditional field which contain BASE_SEGMENT_NUMBER as well in some transaction. means card_no field of card_TXN is having 2 fields i.e. card_no & BASE_SEGMENT_NUMBER. Can anyone guide me that what i have to do with this data and how can i link these (BASE_SEGMENT_NUMBER) with CARDMAST?

      CURRENTLY, the transaction having BASE_SEGMENT_NUMBER are showing under NULL demographical data or portfolio data.. i.e. I couldn't figure out that these transactions are for which product, customer, bucket.. etc.

      Regards,
      SHUMAIL HUSSAIN