Answer Posted / sarvesh
create table newtable as select distinct * from original
tablename;
by doing this we can elimate the duplicate rows
| Is This Answer Correct ? | 6 Yes | 10 No |
Post New Answer View All Answers
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Explain how many types of dimensions are available in informatica?
How to differentiate between the active and passive transformations?
How can you increase the performance in joiner transformation?
What are the main features of Oracle 8i with context to datawarehouse?
What is the need of etl tools?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is an active transformation?
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
without table how to come first record only in oracle?
Why update strategy and union transformations are active?
What is confirmed fact in dataware housing?
How to join three sources using joiner? Explain though mapping flow.
What does “tail –f” command do and what is its use as an Informatica admin.
How to call shell scripts from informatica?