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.
- 2 Answers
- 7105 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / swathi
using source qualifier and also lookup transformation,
joiner lookup
--------------------------------------------
active t/r passive t/r
supports horizontal merging supports horizontal merging
supports only equi join both equi& non equi join
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
if i have a query as flat file how can we load data to target table
What is staging area referring to?
what is different between sequential batch and concurrent batch and which is recommended and why?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
how to load the data to fact table?
what are the reports developed in sap bw project and what is the requirement for developing it?
What is tracing level?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
What are the etl testing operations includes?
when will use SQL override in a lookup transformation?
what is the difference between cardinality and Nullability?
how do u set partition points in the mapping?
What are dimensions?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
