Hello all,
I'm still very new to Informatica (7.1) so please bear with me (doesn't help that I don't have the transformation guide either). I have a recordset already picked up from database tables and running through expression and filter transformations. Now what I'm trying to do is run another conditional based on a SQL query to help arrange that recordset into the appropriate format. To make it clearer, here is an example:
I have an code number that may have 1 or more secondary id numbers associated with it. If it has 1 secondary id associated with it, go with format #1. If it has more than 1 secondary id, go with format #2.
I'm thinking a simple SQL query would do it but I'm not sure what sort of transformation I would need to utilize in order to make this happen. Would another filter transformation be appropriate? If so, how? I don't think the expression editior in the filter condition field accepts SQL?
Thanks very much,
Jisoo23
I'm still very new to Informatica (7.1) so please bear with me (doesn't help that I don't have the transformation guide either). I have a recordset already picked up from database tables and running through expression and filter transformations. Now what I'm trying to do is run another conditional based on a SQL query to help arrange that recordset into the appropriate format. To make it clearer, here is an example:
I have an code number that may have 1 or more secondary id numbers associated with it. If it has 1 secondary id associated with it, go with format #1. If it has more than 1 secondary id, go with format #2.
I'm thinking a simple SQL query would do it but I'm not sure what sort of transformation I would need to utilize in order to make this happen. Would another filter transformation be appropriate? If so, how? I don't think the expression editior in the filter condition field accepts SQL?
Thanks very much,
Jisoo23