is it reqire primary key and foreign key relation ship to
join relational databases?if yes? explain?
- 3 Answers
- 7365 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the issues you have faced in your project? How did you overcome those issues?
What is a sorter transformation?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Do you find any difficulty while working with flat files as source and target?
How can you differentiate between powercenter and power map?
What are the advantages of informatica?
Which is the t/r that builts only single cache memory?
How do you take back up of repository?
How to convert multiple rows to single row (multiple columns) in informatica
Define mapping and session?
Tell me about MD5 functions in informatica
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Can we get 1st record through Informatica(without sequence number).
How do you promote a non-reusable transformation to reusable transformation?
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?
