Automatically match target fields from source to informatica

Question

I have a source structure in computer science, for example

col1 number col2 varchar(40) col3 DATE col4 varchar(50) col5 number 

and my goal definition is similar to

 col4 varchar(50) col1 number col5 number col3 varchar(40) col3 DATE 

If I want to load the source records into the target, I will accordingly display the columns from source to target in a zigzag

I just want to know that if there is any concept, for example informatica, it will automate the fields from source to target based on column names. If the target columns are shuffled but the column names are the same ...

any suggestions on the same would be helpful.

Answer 1

PowerCenter can automatically bind ports between conversions by position and by name .

You should use the latter:

• click Layout > Autolink by Name ,
• select the mapping object that you want to associate (for example, the source), and drag the selected ports to another mapping object (for example, the target).