top button
Flag Notify
Site Registration

Port to Port mapping using Mapping Architect for Visio in Informatica

+1 vote
614 views

I have almost 40 mappings to be created with similar structure. Instead of creating them individually, I was considering that I generate a template in Visio and then generate the mappings using the mapping template.

However, the column names in my source and targets are not consistent. Can I get a drop down while generating the mappings as we get while generating SCD mappings using templates?

Thanks a lot.

posted May 15, 2014 by Madhavi Kumari

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button

Similar Questions
0 votes

How to use a workflow for one to one mapping for more than one source with source name as parameter with different source structure in Informatica power Center. I have a data migration where i need to unload 800 tables into delimited text files. Is there a way we can give the table name in parameter while running the workflow and the data will be unloaded to the output text file. Need help.

0 votes

Can you use a target table in multiple areas of a single mapping.

I have routers around the table, where I know some rows are ready, and currently they are all going to a final Union transformation.

I am wondering if it is possible to direct these from the router, directly into the multiple instance of a single target table.

If so, how does Informatica do the inserts?

Will it each time queue the outputs into the same target, or try and insert them concurrently when and as it stumbles upon them?

0 votes

I am using a stored procedure as a source in my Informatica mapping, and I have defined the SQL query in the source qualifier as

exec dbo.GET_ATTRIBUTES($$fromDate, $$toDate)

where $$fromDate and $$toDate are mapping parameters I have defined in a parameter file. I have tried a number of different ways of going about this and none seem to work, as the SQL query fails to validate.

So, my question boils down to this, is there a way to call a stored procedure while passing in two mapping parameters?

Thanks in advance

0 votes

I have simple informatica(9.1) mapping(one to one) which loads data from flat file to RDBMS

it take 5 mins to load to Oracle db and 20 mins to load same file in SQL Server 2008 R2.

Can there be any source/pointers for performance improvement

...