Eliminating of duplicate records without using dynamic lookups
- 3 Answers
- 6512 Views
- I also Faced
- E-Mail Answers
Answer Posted / kal_leo@hotmail.com
Hi U can eliminate duplicate records by an simple oneline
SQL Query.
select id, count(*) from seq1 group by id having
count(*)>1;
U can run this query directly on any SQL*Plus or U can
override SQL in any transformation.
Hope this is of any help.
Kal
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are three tier systems in etl?
Give the benefits of data integration suite?
What are the three tiers in etl?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
Mention few test cases and explain them?
what is pmrep command?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What is data cleaning?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
what are the types in error loging?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
where we cannot use sorter Transformation. if we use then we will not get correct data?
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
