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

Answer Posted / murthy

use oracle join in SQL override

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how do u set partition points in the mapping?

1802


diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

2098


how many maximum session supports to multiload in teradata ??

1699


What are the modules in Power Mart?

536


what is the use of server manager?

1608






What are the different etl testing categories as per their function?

543


how do u handle performance issues in Informatica . where can u monitor the performance ?

4271


What is the difference between Data Warehousing and Data Mining?

551


What are materialized views & where do we use them?

490


What is a materialized view log?

554


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

2058


what is pmrep command?

10816


What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

558


what are the concerns of OLTP and DSS systems?

1975


HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

1659