How to compare Source and Target table, without using
dynamic lookup?
Answer Posted / b
using MINUS operator in SQ override
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Partition, what happens if the specified key range is shorter and longer
What is depict expression change?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the Rank index port in Rank transformation?
how tokens will generate?
What is an Integration service in Informatica?
What is the cumulative sum and moving sum?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is target load order?
What does reusable transformation mean?
Write the advantages of partitioning a session?
What do you mean incremental aggregation?
what is diff b/t sorter t/r and agg have the option sorter property...
What are the guidelines to be followed while using union transformation?