GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  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