is it reqire primary key and foreign key relation ship to
join relational databases?if yes? explain?
Answer Posted / 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 |
Post New Answer View All Answers
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is an expression transformation?
What is informatica worklet?
What are ETL Tools?
How do you load only null records into target?
Explain the types of lookup transformation?
What is option by which we can run all the sessions in a batch simultaneously?
Explain transaction control transformation in informatica
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Explain about cumulative Sum or moving sum?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How to do unit testing in informatica? How to load data in informatica ?