Comments on ITNirvanas (Datwarehousing/Oracle/Informatica/Unix/D2K Plus interview questions): Normalizer transformation (Working with VSAM sourc...

@Anynymous May be its late reply. But helps somebo...

2012-01-20T01:01:42.060-08:00

@Anynymous
May be its late reply. But helps somebody....
Goto source analyzer --> Edit the VSAM Source --> Ports tab
Where ever you find OCCURS as more than zero, duplicate the columns with the number mentioned in occurs.

Suppose my field10 is occuring 3 times. I can duplicate it as field10_1, field10_2, field10_3.

These three fields holds occuring values.

So, now you can get the values in a single record.

Hi, could you please give me an example for normal...

2010-02-08T05:51:48.570-08:00

Hi,
could you please give me an example for normalizer transformatin for txt(flat file)& relational table as a source file.

Nice article. Let's assume we have a phone num...

2009-10-01T12:07:45.296-07:00

Nice article. Let's assume we have a phone number field with 2 occurs in COBOL file. 1st one to store Home Phone and 2nd one to store Cell Phone. IN target we have 2 different fields for that as well. How can I map these two target fiels from source. The Normalizer created 2 records which I do not want as I have to have one record in Target.