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 is full load & incremental or refresh load?
Which type or t/s is used to convert rows into column & column into rows
What are the etl testing operations includes?
what is the use of server manager?
what is dynamic insert?
Is apache nifi an etl tool?
Can u access a repository created in previous version of Informatica?
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.
Define Dynamic push down optmization?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Identifying the bottlenecks in various components of Informatica and resolving them.
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?