| |
GeekInterview.com > Interview Questions > Data Warehousing > Basics
| Print | |
Question: What is CGID in normalizer transformation
Answer: Please provide me deep info on Normalizer ! |
| June 06, 2009 02:02:01 |
#1 |
| Sirini |
Member Since: June 2009 Total Comments: 3 |
RE: What is CGID in normalizer transformation |
It is GCID which means Generic Column ID. When a Normalizer transformation is used to read Cobol sources, the Informatica Designer identifies the 'OCCURS' and 'REDEFINES' statements and generates 2 columns Generated Key one port for each REDEFINES clause, Generated Column ID one port for each OCCURS clause. Use the Generated column ID and Generated key to create a primary-foreign key relationship. |
| |
Back To Question | |