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

Answer Posted / maruthi

using sql over ride in s.qualfier

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

539


What is full load & incremental or refresh load?

686


What are the steps involved in etl process?

519


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

1442


What are snapshots?

540






How many types of transformations supported by sorted input?

698


what is the use of server manager?

1606


how would u estimate the size of Aggregator transform data and index cache?

1515


Give the benefits of data integration suite?

499


What are the ETL Testing Operations?

626


Two default user groups created in the repository are____and_____.

1653


What is a materialized view log?

551


how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2428


what are the concerns of OLTP and DSS systems?

1559


When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

540