how to create d mapping for the below...

how to create d mapping for the below requirement

Posted in the Informatica Forum

beginner

India

#1 Aug 31, 2010
Source Flat File:



Customer Id Client Id Client Name Customer Name

100 200 CC1 XXX TECH1

100 201 CC2 XXX TECH1

100 202 CC3 XXX TECH1

101 203 CC4 XXX TECH2

101 204 CC5 XXX TECH2

101 205 CC6 XXX TECH2



Output File to be created:



HDXXX

FH100XXX TECH1

DR100200CC1

DR100201CC2

DR100202CC3

FT0003

FH101XXX TECH2

DR101203CC4

DR101204CC5

DR101205CC6

FT0003

TR000600100012



HD File Header, Hard coded value

FH Header record for each customer

DR Detail record for each customer

FT Trailer for each customer, 0003 means number of detail records for each customer

TR File trailer, total detail records, total detail records with customer header and trailers, total detail records with file header and trailer


Use aggregator transformation and post session concatenation, multiple targets.

any idea about this?

Tell me when this thread is updated:

Subscribe Now Add to my Tracker

Add your comments below

Characters left: 4000

Please note by submitting this form you acknowledge that you have read the Terms of Service and the comment you are posting is in compliance with such terms. Be polite. Inappropriate posts may be removed by the moderator. Send us your feedback.

Informatica Discussions

Title Updated Last By Comments
Informatica Admin & Cloud Deployment (May '17) May '17 avi_infa 1
Converting row data to column data (Sep '16) Sep '16 Roopa 1
How to Handle Horizontal tab in Flat file in in... (Sep '15) Jul '16 ann_p 2
active and passive t/f (Feb '16) Jul '16 ann_p 2
Loading a specific Erwin model version into Met... (Apr '16) Apr '16 SCHJA26 1
not recognizing the source file (Jun '08) Mar '16 Jayashree 2
calling informatica powercentre workflow as a s... (Mar '16) Mar '16 anil 1
More from around the web