Transformations

Hello,
We are going through a 2 week trial with informatica.
I have found how to put e-mails into the post-sessions
but I'm having trouble with the following.
1) Translate MR2000 CBL + Revenue Type Code into SCDM
Category_ID. If not found, generate new Category_ID
2) Check if 13-digit BTN (to 13-digit BTN) exists in
SMT.BLG_ACCT_TEL_NBR. If found and there are
multiple, use the most recent one.

Were is this in the doc explaining about generating
new rows?

Any recommendation on the approach we should take in
creating this?

I'm using Informatica 6.2. Its a DB2 database and the
server is on HP.

Please describe the tables and fields (number?text?varchar?)
in a more detail way if possible....
> Read today's most popular Informatica career discussion.
> http://DW.ITtoolbox.com/r/da.asp?r=3572>
> Hello,
> We are going through a 2 week trial with informatica.
> I have found how to put e-mails into the post-sessions
> but I'm having trouble with the following.
> 1) Translate MR2000 CBL + Revenue Type Code into SCDM
> Category_ID. If not found, generate new Category_ID
> 2) Check if 13-digit BTN (to 13-digit BTN) exists in
> SMT.BLG_ACCT_TEL_NBR. If found and there are
> multiple, use the most recent one.
>
> Were is this in the doc explaining about generating
> new rows?
>
> Any recommendation on the approach we should take in
> creating this?
>
> I'm using Informatica 6.2. Its a DB2 database and the
> server is on HP.
>
> Thanks
>
>

Technically based on the defenition even Exp TFM can turn into a active tfm. Suppose you have a code on a specific port (say char data type) and you are checking it's value for some kind of validity and if it fails you error it out then that row doesn't pass thru the TFM. Now the number of rows in the output is less that the input....
In sorter tfm there are no change in number of rows but still it is an active tfm.
--KRishnan