Interested to Buy Any Domain ? << Click Here >> for more details...
What are the diffrences between joiner transformation and
source qualifier transformation?
- 2 Answers
- 17409 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha
yoU can join hetrogenious data sources in joiner
transformation which we can not achieve in source qualifier
transformation. yoU need matching keys to join two
relational sources in source qualifier transformation. Where
as you doesn't need matching keys to join two sources. Two
relational sources should come from same datasource in
source qualifier. yoU can join relatinal sources which aer
coming from different sources also.
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / 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 |
What are the mapping parameters and mapping variables?
What is a data modeling?
What are the components of the workflow manager?
what is the difference between Informatica7.1 & informatica 8.1
What is rank transformation?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
Explain the code page compatibility?
In dimension and fact table? which one holds big data?
how do the project develops? pls specify right from the start to end in step by steps.
What are the different versions of informatica?
what is a transforamation?
what happens when a batch fails?
Teradata 
