Skip navigation
Contact Us
771 Views 4 Replies Latest reply: Jan 17, 2013 5:40 PM by DATAWAREHOUSE DATA RSS
patil kumar Newbie 8 posts since
Dec 11, 2012
Currently Being Moderated

Dec 11, 2012 12:42 AM

need help on below senerios

1.Create a table like stage_customer and add mapping logic to find errors (more than 1 error

in multiple columns)  and append the errord descriptions to the last column in the table

like error_desc and if atleast one error is there ... populate the error_flag column in the

same table with Y or N

 

2.lhow to Transpose Columns to rows i.e one record in source will get transposed to 3

records in target

  • Veeru B Master 1,242 posts since
    Sep 27, 2010
    Currently Being Moderated
    Dec 11, 2012 12:50 AM (in response to patil kumar)
    need help on below senerios

    Hi Patil,

     

    Please provide some sample data and expected result so that it will be helpful to provide any suggestions.

     

    Regards,

    Veeru

      • Prasad K Newbie 3 posts since
        Oct 16, 2012
        Currently Being Moderated
        Dec 11, 2012 1:13 AM (in response to patil kumar)
        need help on below senerios

        Hi Patil,

         

                  You can achieve it like this. For each of your input ports, create a new variable port with logic as:

         

               Var_Port1 = IIF(ISNULL(INPORT1), "Port1 is NULL",(IS_SPACES(INPORT1),"Port1 is Spaces",NULL),NULL)

         

                So if your input port1 is either NULL or Spaces, your Var_Port1 will have some text otherwise it will be NULL. You can do the same for all your input ports. And have one more variable port ERROR_DESC. You can concatenate all the variable ports described above and populate it.

         

        For your second requirement, you can create a normalizer transformation.

         

        Rgds,

        Prasad K

  • DATAWAREHOUSE DATA Newbie 7 posts since
    Jan 13, 2013
    Currently Being Moderated
    Jan 17, 2013 5:40 PM (in response to patil kumar)
    need help on below senerios

    Hai,

     

       You should use expression transformation, in that you shold use decode function also.

     

    For further information reach at

     

    http://dwbiadda.blogspot.in/

More Like This

  • Retrieving data ...

Bookmarked By (0)