how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
Answers were Sorted based on User's Feedback
Answer / guest
we can join two table by using source qualifier t/r
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / 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 |
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
What are the different etl testing categories as per their function?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
What is lookup table in etl testing?
What is the difference between round-robin partitioning and hash partitioning?
How etl testing is different from database testing?
how do use session mapping parameters ?(in which transformation)
how do u set partition points in the mapping?
What exact we can see in table?
Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?
how many maximum session supports to multiload in teradata ??
how do u implement configuration management in Informatica?