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
what is informatica metadata?
What are Dimensional table?
Performance tuning( what you did in performance tuning)
wf dont have integration severances how you can run?
Explain about Informatica server process that how it works relates to mapping variables?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is standalone command task?
What is a stored procedure transformation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is xml source qualifier transformation in informatica?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What are some examples of informatica etl programs?
Design time, run time. If you don't create parameter what will happen
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How to start a workflow using pmcmd command?