how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
Answer Posted / k.rameshyadav
Lookup T/R is always is an alternate for joiner.
If the sources are same i.e homogenous we can perform join at database level.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the different Lookup methods used in Informatica?
What is the difference between round-robin partitioning and hash partitioning?
How to increase performance without changing anything in mapping.( In prod)
what is different between sequential batch and concurrent batch and which is recommended and why?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
What is partitioning? Explain different types of partitioning?
how do use session mapping parameters ?(in which transformation)
What is grain of fact?
what is session partitioning?
What is fact? What are the types of facts?
what are the production issues in datastage?
In Which Transformation We Can Use Having Clause In Informatica?
Explain about enterprise scalability and roi of data integration suite?
Explain about round-robi?
What is initial load and what is full load?