How can we join the tables if they don't have primary and
foreign key relationship and no matching port?

Answer Posted / ramz

use Cartesian product or cross join
select required columns from tab1,tab2;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is informatica metadata?

595


What are Dimensional table?

606


Performance tuning( what you did in performance tuning)

1483


wf dont have integration severances how you can run?

1539


Explain about Informatica server process that how it works relates to mapping variables?

618






What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

710


What is standalone command task?

705


What is a stored procedure transformation?

607


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1590


What is xml source qualifier transformation in informatica?

709


hi real timers . iam waiting for ur reply regarding ETL TESTING

1802


What are some examples of informatica etl programs?

529


Design time, run time. If you don't create parameter what will happen

1422


While importing the relational source definition from the database, what are the metadata of source that will be imported?

784


How to start a workflow using pmcmd command?

707