What are the diffrences between joiner transformation and
source qualifier transformation?
Answer Posted / david
One important thing is
IN source Qualifier 1)the columns used in the condition must
have primary-key and foreign-key relationship(Compulsory)
For example
If the condition is
Emp.deptno = dept.deptno1
The depeno and deptno1 should have primary and foreign
key relation
2)The datatypes of the couumns must be same
Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Scheduling properties,whats the default (sequential)
Could you explain what is enterprise data warehouse?
What is powercenter on grid?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Why do we need informatica?
State the differences between sql override and lookup override?
How do you promote a non-reusable transformation to reusable transformation?
Is it possible to use a client with different version than that of its Informatica server?
Partition, what happens if the specified key range is shorter and longer
What is the use of transformation?
How big was your fact table
What are the differences between source qualifier and joiner transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is the session task and command task?
What is the function of look up transformation?