write a query for how to eliminate the duplicate rows
without using distinct?
Answer Posted / bharu_295
select count(*),col1,col2 ..... from table_name
groupby col1,col2.....
having count(*)>1
Is This Answer Correct ? | 2 Yes | 9 No |
Post New Answer View All Answers
What is native users?
What is meant by a domain?
Why do you use Mapping Parameter and mapping variable?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
design of staging area?
How to create the source and target database connections in server manager?
What is event and what are the tasks related to it?
What is rank transformation in informatica
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Explain 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?
Explain target update override in informatica
lookup transformation with screenshots
What is the benefit of session partitioning?
What is an expression transformation in informatica?