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
What is an expression transformation in informatica?
Sequence generator, when you move from develoment to production how will you reset
In which transformation you cannot drag ports into it?
design of staging area?
Define mapplet?
What is standalone command task?
Which are the different editions of informatica powercenter that are available?
What is meant by query override?
What is an expression transformation?
Explain constraint based loading in informatica
What are the types of schemas we have in data warehouse and what are the difference between them?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is rank transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Does an informatica transformation support only aggregate expressions?