How to compare Source and Target table, without using
dynamic lookup?

Answer Posted / nagaraju bhatraju

YOu can join the Source and target columns at the source
qualifer level,if you have public synonym on the target, so
that the table can be accessed from all the schemas.

Is This Answer Correct ?    6 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain about unit testing? in real time?

1658


How is union transformation utilized?

567


Where are the source flat files kept before running the session?

624


What could be the possible resons of locks by user?

659


Explain the pipeline partition with real time example?

651






What are the differences between a connected lookup and unconnected lookup?

646


Enlist the advantages of informatica.

628


What is the procedure for creating independent data marts from informatica 7.1?

564


without table how to come first record only in oracle?

1849


Where do we use mapping variables in informatica?

613


What is meant by lookup transformation? Explain the types of lookup transformation?

567


tell me the rules and responsblites in our project(my project is development)

1495


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1932


Implementation methodology

1260


How an expression transformation differs from aggregator transformation?

626