Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 4 Answers
- 15265 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
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
how to connect to a flatfile through ftp in informatica
Explain etl mapping sheets?
What are various etl tools in the market?
What is the difference between project backlog and product backlog?
When do we go for the tools in the market?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
When do we analyze the tables?
what is data modeling?
Explain the use lookup tables and Aggregate tables?
what is a worklet?
List few etl bugs?
what is dynamic insert?
What is Data Vault???
what make u disappointmnets in u r career
