Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 4 Answers
- 15449 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
Explain the key challenges that you face while performing etl testing.
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
What is meant by incremental load?
what is a worklet?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
dimension object created in oracle can be imported in designer?how?
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 are the steps involved in etl process?
What is etl process?
How many steps etl contains?
what is dynamic insert?
what is the use of server?
Difference between flat files and relational sources?
Explain about the data integration suite features?
State the differences between shortcut and reusable transformation
