write a query for how to eliminate the duplicate rows
without using distinct?
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
How would you copy the content of one repository to another repository?
What is the different lookup cache(s)?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What are the different versions of informatica?
Parameter and variable differences
What are the measure objects?
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
Explain lookup transformation source types in informatica
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Why update strategy and union transformations are active? Explain with examples.
What are the prerequisite tasks to achieve the session partition?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is mapping debugger?
Differentiate between joiner and lookup transformation?
How do you change a non-reusable transformation to reusable transformation?