Interested to Buy Any Domain ? << Click Here >> for more details...
What are the diffrences between joiner transformation and
source qualifier transformation?
- 2 Answers
- 17411 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the measure objects?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How to differentiate between the active and passive transformations?
What is the scenario which compels informatica server to reject files?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Under what condition selecting sorted input in aggregator may fail the session?
What are the restrictions of union transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Performance tuning in UNIX for informatica mappings?
wat are deployement groups in informatica, how it will be used for developers
What is meant by active and passive transformation?
what is INFORMATICA TESTING process
Why sorter is an active transformation?
What is workflow? What are the components of the workflow manager?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
