Interested to Buy Any Domain ? << Click Here >> for more details...
write a query for how to eliminate the duplicate rows
without using distinct?
- 6 Answers
- 12082 Views
- iGate, I also Faced
- E-Mail Answers
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
can we override a native sql query within informatica? Where do we do it?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How to update or delete the rows in a target, which do not have key fields?
Why union transformation is an active transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How do you convert single row from source into three rows into target?
Mention some types of transformation?
What is standalone command task?
Explain the code page compatibility?
What are different types of transformations available in informatica?
Make a note of the quantity vaults made in informatica?
What is the difference between Active and Passive transformation?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How can we store previous session logs?
