Can you use one mapping to populate two tables in different
schemas

Answer Posted / sanjay

Use $DBConnection instead of connection in session for
source and change the schema name through the parameter file

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How you prepared reports for OLAP?

1142


What is informatica metadata and where is it stored?

575


Can we override a native sql query within informatica?

622


What are the main features of Oracle 8i with context to datawarehouse?

1670


What are the types of schemas we have in data warehouse.

522






How to configure mapping in informatica?

666


How to create a non-reusable instance of reusable transformations?

668


what is the size of u r source(like file or table)?

1808


How to do unit testing in informatica?

712


Explain the types of lookup transformation?

560


What are active transformations.

1179


Which development components of informatica have the highest usage?

582


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

666


State the limitations where we cannot use joiner in the mapping pipeline?

541


Partition, what happens if the specified key range is shorter and longer

2025