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 |
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How to load time dimension?
connected and unconnected lookups?
In which circumstances that informatica server creates Reject files?
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
what is the difference between lookupoveride and joiner?
What are the two modes of datamovement in informatica sever?
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
HOW DO YOU PARFORM INCREMENTAL LAOD ?
What is Target Update Override? What is the Use ?
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
What is the commit type if you have a transaction control transformation in the mapping?