i have two source data there is no pk,fk how to join the
two sources

Answer Posted / chandrababu.sarupuru

To join these sources we will use SQL Override function in
Source qlalifier transformation....

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

669


What is meant by active and passive transformation?

578


What is the different lookup cache(s)?

605


In which transformation you cannot drag ports into it?

774


Explain the different kinds of facts.

554






Write the different tools in the workflow manager?

567


How do you update the records with or without using update strategy?

653


What is a code page?

703


What is powercenter on grid?

686


Explain the aggregator transformation?

621


What are the types of schemas we have in data warehouse and what are the difference between them?

513


How can informatica be used for an organization?

642


How many ways a relational source definition can be updated and what are they?

573


how to load rows into fact table in data warehouse

634


How does the aggregator transformation handle null values?

693