how can one eliminate dupliacte data with out using
distinct option?
Answer Posted / arpan
U can use Sorter Transformation and there is an option as
Select Distinct.
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is a sorter transformation?
What is the cumulative sum and moving sum?
Mention few power centre client applications with their basic purpose?
Clarify the utilization of aggregator cache record?
What are the types of data warehouses?
In development project what is the process to follow for an etl developer from day1
How does the aggregator transformation handle null values?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Define update strategy?
Explain the scenario which compels informatica server to reject files?
How many input parameters can exist in an unconnected lookup?
What are the new features of Power Center 5.0?
During the running session, output files are created by informatica server. Enlist few of them.
Can we create a Integration service without a Repository service and vice versa?