Interested to Buy Any Domain ? << Click Here >> for more details...
i having mapping
emp---> sq_emp--->target
using this mapping i have to load dept table values into
target... (condition assume there is no primary and foreign
key relation between emp(table x) and dept (table Y))
- 5 Answers
- 9894 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / babu
U CAN WRITE SQL OVERRIDE( SELECT
DEPT.DEPTNO,DEPT.DNAME,DEPT.LOC FROM DEPT)
AND U CONNECT SOURE TO TARGET ONLY 3 PORTS THOSE DATA TYPES
MUST BE MATCHED.
EMP-->SQ_EMP---->TRG
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are the limitations of joiner transformation?
What will be the approach?
What can we do to improve the performance of informatica aggregator transformation?
Explain dynamic target flat file name generation in informatica
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is dynamic cache?
Whats the difference between informatica powercenter server, repositoryserver and repository?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain load alternative records / rows into multiple targets - informatica
Plz can any one say me how to get the informatica certification materials and dumps
What is a grid in Informatica?
Informatica settings are available in which file?
How can you increase the performance in joiner transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
When do you use sql override in a lookup transformation?
