Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicates from flat file..what is the
procedure
- 4 Answers
- 8519 Views
- I also Faced
- E-Mail Answers
Answer Posted / muddam
Select all ports as group by then Create one o/p o_count in
aggregater(o_count>1). Before this you wolud have taken one
sorter trans for sorted data.
It will work out.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain transaction control transformation in informatica
What are batches?
Explain the types of lookup transformation?
How to load last n records of file into target table - informatica
What is the need for an etl tool?
What is substr in informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is an aggregator transformation?
COM components can be used in Informatica
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is the benefit of partitioning a session?
What is meant by active and passive transformation?
What is informatica?
What are the new features of Power Center 5.0?
Explain informatica architecture - version 8 / 9
