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
wat are deployement groups in informatica, how it will be used for developers
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is target designer and target load order?
What is the function of union transformation?
Explain sessions and how many types of sessions are there?
Which is the t/r that builts only single cache memory?
What is the difference between router and filter?
What do you mean by channel change?
How many numbers of sessions can one group in batches?
When do you use sql override in a lookup transformation?
server hot-ws270 is connect to Repository B. What does it mean?
waht type of interface is used for testing the data in informatica
Plz can any one say me how to get the informatica certification materials and dumps
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is aggregate cache in aggregator transformation?