write a query for how to eliminate the duplicate rows
without using distinct?
- 6 Answers
- 10292 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / abhishek kumar
select id from tgt_table group by id;
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
What is the way to execute pl/sql script using informatica mapping?
Mention few advantages of router transformation over filter transformation.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is aggregate cache in aggregator transformation?
What are the new features of informatica 9.x at the developer level?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is an Integration service in Informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is the different lookup cache(s)?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What can we do to improve the performance of informatica aggregator transformation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Enlist the various types of transformations.
