hw cn v elimate dublicate values from lookup without
overriding sql?
Answer Posted / preeti
hi,if I understand this question correctly,lookup itself
eliminate duplicate rows by having options like First
Value,Last Value.So whenever there are more than one row
for matching lookup condition then it gets eliminated by
first value.last Value option.Let me know if I am wrong
| Is This Answer Correct ? | 33 Yes | 2 No |
Post New Answer View All Answers
What is data transformation manager process?
how many types of dimensions are available in informatica?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How to create or import flat file definition in to the warehouse designer?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How many dimensions are there in informatica?
Why update strategy and union transformations are active? Explain with examples.
Can we change Dynamic to Static or Persistent cache? If so what happens?
permutations of mapplet
What are the components of workflow manager?
State the limitations where we cannot use joiner in the mapping pipeline?
Describe data concatenation?
Could you explain what is enterprise data warehouse?
Partition, what happens if the specified key range is shorter and longer
What is native users?