Eliminating of duplicate records without using dynamic lookups
- 4 Answers
- 14509 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
can be used COM component in Informatica ?
Compare etl & elt?
Is hadoop a etl tool?
What are the differences between sql override and update override?
what are the facilities provided by data warehouse to analytical users?
What is etl tool in hadoop?
what is granularity in Data ware House?
how would u estimate the size of Lookup transform data and index cache?
Explain about hash partitioning?
Difference between flat files and relational sources?
What do you understand by active and passive transformations?
Define slowly changing dimensions (SCD)?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
how do u set partition points in the mapping?
