Eliminating of duplicate records without using dynamic lookups
Answer Posted / bhagya
1) By enabling the option in sorter transformation as
select distinct
(or)
2) By enabling all the values as group by in aggreagator
transformation
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what is dynamic insert?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
What is grain of fact?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
What is Data Vault???
What are the different etl testing categories as per their function?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
What is data cleaning?
What is abap? What are idocs?
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
what are the cubes developed in a sap bw project and what is the requirement for developing it?
dimension object created in oracle can be imported in designer?how?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
what are Lookup caches options? Including persistent caches.