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
Is there any target staging area in informatica not staging area
What are the static cache and dynamic cache in informatica?
Define pmcmd command?
How do you load unique records into one target table and duplicate records into a different target table?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
design of staging area?
What are the differences between a connected lookup and unconnected lookup?
What are connected or unconnected transformations?
What is dynamic cache?
What is enterprise data warehousing?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Why is sorter an active transformation?
How to create the source and target database connections in server manager?
How to join three sources using joiner? Explain though mapping flow.
What are the different transaction levels available in transaction control transformation?