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))
Answer Posted / kalim
Using SQL Overide we can reach the goal.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are active transformations.
What are the types of data warehouses?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the components of the workflow manager?
Clarify the utilization of aggregator cache record?
what is index?how it can work in informatica
Which files are created during the session rums by informatics server?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is deployment group?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What are connected or unconnected transformations?
What are the different types of olap? Give an example?
what is song in infrmatica...?
What is fact table? Explain the different kinds of facts.