how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how do use session mapping parameters ?(in which transformation)

1442


What are dimensions?

578


what are the types in error loging?

1637


Compare ETL & Manual development?

554


What is data modeling and data mining?

558






What is etl process?

538


what is an ETL or ETT? And what are the different types?

6928


How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

791


how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

2056


Do we need an ETL tool? When do we go for the tools in the market?

526


list and discuss two approaches for updation of target table in Informatica and how they are different.

1735


what is the difference steps for data modeling?

2082


How to fine tune mappings?

566


What is partitioning? Explain about round-robin, hash partitioning.

550


Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

1806