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 / kasi reddy
using lookup T/R we can join the two tables and using
source qualifier t/r we can join the table
| Is This Answer Correct ? | 3 Yes | 1 No |
how would u estimate the size of Lookup transform data and index cache?
What are the new features of informatica 9 version?
working of line item dimension......pls,tell overall flow
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
Explain me ETL project architecture in Detail?
What is etl process. How many steps etl contains explain with example?
what are the different forms of normalization?
what is the difference between OLTP database and data warehousing database?
we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record
what are business components in Informatica?
what is the difference steps for data modeling?
Eliminating of duplicate records without using dynamic lookups