How to eliminate duplicates from flat file..what is the
procedure
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
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How can we use mapping variables in informatica? Where do we use them?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Implementation methodology
Explain pmcmd command usage in informatica
What are the basic requirements to join two sources in a source qualifier transformation using default join?
differences between service based and product based?
What are the types of caches in lookup?
How can we update a record in the target table without using update strategy?
Design time, run time. If you don't create parameter what will happen
What is meant by query override?
Reusable transformation and shortcut differences
what is the complex transformation you used in informatica
Separate from an archive server and a powerhouse?