Answer Posted / mayuri
Select ditinct in properties of source qualifier
transformation.
| Is This Answer Correct ? | 21 Yes | 6 No |
Post New Answer View All Answers
Explain about cumulative Sum or moving sum?
How many ways are there to create ports?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is informatica worklet?
How can you differentiate between powercenter and power map?
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
What are the settings that you use to configure the joiner transformation?
How do you load first and last records into target table?
Explain the shared cache and re-cache?
What are the types of data warehouses?
Which is the t/r that builts only single cache memory?
What is the surrogate key?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
explain abt ur project architecture?
What is the format of informatica objects in a repository?