Interested to Buy Any Domain ? << Click Here >> for more details...
is it reqire primary key and foreign key relation ship to
join relational databases?if yes? explain?
- 3 Answers
- 8628 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mike
If you are performing the join using a SOURCE QUALIFIER ,
the relational sources should have a primary and foreign
key relationship.
If you are performing the join using a JOINER, no need to
have a primary and foreign key relationship.
| Is This Answer Correct ? | 10 Yes | 5 No |
Answer / usha
we want join in SQ we should have primary key and foreign
key relation ship ...
but, in joiner we dont need primary key and foreign key
relation ship
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bharu_295
if u want to join the tables we need to have primary and foreign key relationship other wise if we join we get Cartesian product of the data.
| Is This Answer Correct ? | 1 Yes | 2 No |
What are the types of maping wizards that r to be provided in Informatica?
What is the Process to creating lookup transformation in informatica
How to load duplicate records in to a target table which has a primary key?
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
What are pre and post-session shell commands?
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
Briefly describe lookup transformation?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
What is polling?
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
How can we use batches?
Teradata 
