how to connect two or more table with single source qualifier?

Answer Posted / kish

hi,

by using sql override....

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a repository manager?

650


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

779


What is the use of an aggregator cache file?

694


How would you join a node to the already existing domain?

683


What is domain and gateway node?

702






What are the different clients of powercenter?

604


Different qualification between a related rotate toward the sky and isolates look upward?

556


explain one complex mapping with logic? sales project?

6154


What is the cumulative sum and moving sum?

760


What is the benefit of session partitioning?

601


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

786


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

641


What is different between the data warehouse and data mart?

630


Explain how to import oracle sequence into informatica?

594


How does the aggregator transformation handle null values?

703