Using Informatica for one to one mapping for more than one source with different source structure -

Using Informatica for one to one mapping for more than one source with different source structure -

how utilize workflow 1 1 mapping more 1 source source name parameter different source construction in informatica powerfulness center? have info migration need unload 800 tables delimited text files.

is there way can give table name in parameter while running workflow , info unloaded output text file?

in informatica powercenter, you'll need separate mapping each structure. eg. if each 1 of 800 tables mentioned has unique construction , / or datatypes, you'll need 800 mappings. if construction shared across 800 tables, 1 mapping can handle it. , if you've got 4 different structures, 4 mappings do.

if have 800 different structures, great automate it. if understand correctly, need work this:

http://powercenternotes.blogspot.com/2013/05/stage-mapping-generator.html,

but in reverse direction (table-to-file, rather file-to-table). if that's correct, sense free contact me - think i'd able prepare similar solution

informatica informatica-powercenter