How to eliminate duplicates from flat file..what is the
procedure

Answer Posted / paulo coelho

In an Unix environment, do:

page YourFile | sort | uniq -c

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is olap (on-line analytical processing?

632


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.

1243


What happens when a session fails and you click on recover?

649


Scheduling properties,whats the default (sequential)

1454


Reusable transformation and shortcut differences

1366






I have a flat file, want to reverse the contents of the flat file

684


What is sq transformation?

653


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4303


What are the differences between oltp and olap?

543


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1859


How do you remove duplicate records in informatica? And how many ways are there to do it?

700


What are the differences between a connected lookup and unconnected lookup?

639


Differentiate between joiner and lookup transformation?

606


What is a mapplet/worklet in informatica?

678


What are the types of data warehouses?

936