Can you use one mapping to populate two tables in different
schemas
Answers were Sorted based on User's Feedback
Answer / pal
Yes we can use one mapping to populate data in multiple
schemas.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
What is data transformation manager process?
What is the filename which you need to configure in UNIX while installing infromatica?
How you know when to use a static cache and dynamic cache in lookup transformation?
How can you validate all mappings in the repository simultaneously?
why we r using presql&postsql in source qualifier?
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
What is workflow? What are the components of the workflow manager?
What is the benefit of partitioning a session?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
what is system requirement(SR) & business requirement(BR)?
Limitation of REPLACESTR. Is there any character limitation to it.