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
Regarding my first senerion....if any one of the columns comming from the source is having space or null values then i need to report as error and populate this error message to target by adding column as error desc toTarget tables as "ERROR in Columns 1 or 2 or 3 ....N having Space or null " values like that
at same time i need to create one extara colums in target as error_flag Y if error found N is not error deticated
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.