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
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
what is $$$$?
what is the size of your data warehousing?
What is primary and backup node?
How an expression transformation differs from aggregator transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are the guidelines to be followed while using union transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Explain the features of connected and unconnected lookup.
What do you mean by enterprise data warehousing?
What is parallel processing in informatica?
What are the tasks that source qualifier perform?
What are the mapping parameters and mapping variables?
can we override a native sql query within informatica? How do we do it?
what is diff b/t sorter t/r and agg have the option sorter property...