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


Please Help Members By Posting Answers For Below Questions

What is a materialized view log?

554


what is the use of structures?how many nodes can u create in a structure?

1760


What is fact? What are the types of facts?

540


what do u do when DB time takes more?in sap bi

1787


What do you understand by active and passive transformations?

554






What is a lookup table in etl?

600


how to connect to a flatfile through ftp in informatica

13447


What is tracing level? How many types of transformations supported by sorted input?

552


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


what are the reports developed in sap bw project and what is the requirement for developing it?

1777


What is data modeling and data mining?

560


What is cube grouping?

569


Explain etl?

578


what is the difference steps for data modeling?

2083


what is Forward,Reverse and Re_engineering?

1733