Interested to Buy Any Domain ? << Click Here >> for more details...
how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
- 5 Answers
- 16333 Views
- I also Faced
- E-Mail Answers
Answer Posted / k bhavani durga
this can be used to join two sources coming from two
different locations or from the same locayion.for this
there mist be atleast one matching port and it is must to
specify one source as master and the other as detail.
it supports the following types of joins
1.normal
2.master outer
3.detail outer
4.full outer
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
SCD2 will work on only dimension tables as well as fact Table?
flat filevalidation in informatica
what are the reports developed in sap bw project and what is the requirement for developing it?
what is the difference between cubes and package in cognos
What is tracing level and what are the types?
Do we need an etl tool?
what are Lookup caches options? Including persistent caches.
Can we create Hierarchies in generic datasources?
What are the modules in Power Mart?
What is staging area referring to?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Define slowly changing dimensions (SCD)?
what are the production issues in datastage?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What is lookup table in etl testing?
