Informatica (ETL) - Normalizer Transformation
Loading...
Loading...
2,971
Loading...
Uploaded by amr3shjha on Aug 20, 2011
In this video working with Normalizer transformation along with flat file concept is explained.
For more Concepts you can visit :
http://informatica-developers.blogspot.com/
Uploader Comments (amr3shjha)
see all
All Comments (6)
-
and i also want to know what are those 2 field GK_PHONE and GCID_PHONE and why are they used.....???
please reply....
-
hi....
i have hear that there are some ID's also generated along with these data why couldn'
t i see them in your out put file...
please reply.....
-
Manish, this is a great video. However, Normalizer transformation should be called as Pivot transformation.
Another confusion by Informatica
Loading...
12:06
NORMALIZER TRANSFORMATION IN INFORMATICA BY MANISHby TheMax93631,716 views- 6:04
Informatica (ETL) - Creating Source & Target Definationsby amr3shjha823 views
- 4:56
What is an ETL Tool?by Intricity1013,497 views
- 14:23
Informatica (ETL) - Source Qualifier Overrideby amr3shjha1,991 views
- 16:43
Using Slowly Changing Dimensions Transformation in Centerprise Data Integratorby AsteraSoftware1,458 views
- 10:30
Informatica Training - Using Joiner and Sorter Transformation Part 6 of 20by BharatiDWConsultancy1,428 views
- 10:43
UNION TRANSFORMATION IN INFORMATICAby TheMax93632,641 views
- 4:58
Lookup - Connected Cachedby b85in3,087 views
- 9:55
Informatica: How-To: Move Data From Source Database to Target Database Using Informatica PART-2by TheTechnicalSkills6,998 views
- 6:13
Business Intelligence and Data Warehousingby ecognosys9,487 views
- 10:44
MAPPING VARIABLE IN INFORMATICA BY MANISHby TheMax93632,774 views
- 9:23
Informatica Training - Using Joiner and Aggregate Transformation Part 4 of 20by BharatiDWConsultancy664 views
- 11:20
Informatica Training - Using Expression Transformation Part 7 of 20by BharatiDWConsultancy771 views
- 6:42
Informatica Training Using Rank & Sequence Gen Transformation Part 5 of 20by BharatiDWConsultancy804 views
- 7:47
Joiner Transformationby youngistan58501 views
- 3:11
Informatica Tutorials for Beginnersby tutorialblogs9,979 views
- 5:56
Compare Rows in Informaticaby b85in7,502 views
- 5:55
Informatica: How-To: Generate Flat File Using Informatica Part2by TheTechnicalSkills5,506 views
- 5:27
Informatica Training - Using Debugger Part 10 of 20by BharatiDWConsultancy571 views
- 4:39
Informatica | Create a Web Services Hubby fyghtsoft1,854 views
If there are 12 rows and 4 multiple occurring column then the total number of generated key will be 12*4=48. Means total number of records return will be the GK max value. Or 4 multiple occurring columns the GCID will be (1, 2, 3, 4) for 12 times.
--Amresh Jha
amr3shjha 1 month ago
The Normalizer transformation has a generated column ID (GCID) port for each multiple-occurring column. The generated column ID is an index for the instance of the multiple-occurring data. The Normalizer transformation has at least one generated key (GK) port. The Integration Service increments the generated key sequence number each time it processes a source row.
amr3shjha 1 month ago
Yes correct ! If you have previous knowledge on this matter you c'd call this/relate as Pivot transformation. As in many places this normalization/denorm are also know as pivot/depivot .
amr3shjha 4 months ago