Interested to Buy Any Domain ? << Click Here >> for more details...
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
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Differentiate between a repository server and a powerhouse?
Which is the t/r that builts only single cache memory?
What are the different types of olap? Give an example?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How to join three sources using joiner? Explain though mapping flow.
What are session parameters ? How do you set them?
What is the maplet?
How can we use batches?
What is dimensional table? Explain the different dimensions.
Explain joiner transformation in informatica
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
generate date / time dimension in informatica
write a query to retrieve the latest records from the table sorted by version(scd)
Can we create a node as a gateway node and the same node can be assigned to a grid?
