Interested to Buy Any Domain ? << Click Here >> for more details...
What are the diffrences between joiner transformation and
source qualifier transformation?
- 2 Answers
- 17343 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 |
in which situations do u go for scds ?
Describe data concatenation?
Explain why we use partitioning the session in informatica?
can we override a native sql query within informatica? Where do we do it? How do we do it?
without table how to come first record only in oracle?
difference between shortcut and reusable transformation?
what is the difference between repository & Intergration service
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
How to do the error handling of if ur source is flatfiles?
What are the static cache and dynamic cache in informatica?
Explain the difference between a data warehouse and a data mart?
Teradata 
