Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 4 Answers
- 15524 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / raghav
with out distinct we can do it in 3 possible ways.
1. Using Group by function which will act like a distinct in
TD13.0 database
2. using SET table concept, like first we create the multi
set table and insert the duplicate rows into them and then
create the set table and use the insertselcet concept, in
this case only distinct rows will be inserted.
3. use rowid, derived table or sub query concept then we can
do this
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are your responsibilities as an etl tester?
What are cubes and olap cubes?
what are the reporting tools and difference between them?
Explain the use lookup tables and Aggregate tables?
What are various etl tools in the market?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
What is full load & incremental or refresh load?
Two default user groups created in the repository are____and_____.
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
Do we need an etl tool?
What is the difference between project backlog and product backlog?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
What is abap? What are idocs?
What are three tier systems in etl?
