1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

without matching columns in two tables. how can you join

Question Posted / ankit kansal

Answer Posted / ankit kansal

Its against the concept of Normalization to join two tables without PK and FK relationship. however if you try to join both tables then it will return you Cartesian product.
lets say your first of your table contains = 12 rows and
the other one also contains 12 rows then net output will be 144 rows.

http://deepinopensource.blogspot.in/

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

scenario where i can use only concurrent execution of workflow.

2643

What is the benefit of partitioning a session?

740

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1681

What is rank transformation in informatica

801

How can we use mapping variables in informatica? Where do we use them?

731




can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4409

What is the difference between source qualifier transformations source filter to filter transformation?

709

Briefly explain the aggregator transformation?

689

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1904

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1628

Performance tuning in UNIX for informatica mappings?

2246

Explain what are the different types of transformation available in informatica.

664

What is event and what are the tasks related to it?

707

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1630

Can informatica load heterogeneous targets from heterogeneous sources?

814