how will you remove the duplicate records from flat file
without using sorter?
Answer Posted / krishnakanthch
We can use the option 'SELECT DISTINCT' in the source
qualifier.
Anybody please tell me whether this works or not.
| Is This Answer Correct ? | 5 Yes | 23 No |
Post New Answer View All Answers
What is xml source qualifier transformation in informatica?
Enlist some properties of sessions.
What are the components of workflow manager?
Can we create a Integration service without a Repository service and vice versa?
explain about unit testing? in real time?
What is substr in informatica?
What is incremental aggregation?
Describe expression transformation?
Which development components of informatica have the highest usage?
What is the benefit of session partitioning?
Describe the impact of several join conditions and join order in a joiner transformation?
Explain in detail scd type 2 through mapping.
How do you migrate data from one environment to another?
How we can create indexes after completing the load process?
How might one distinguish in the case of mapping is right or not without associating session?