Interested to Buy Any Domain ? << Click Here >> for more details...
In a table there are 1 million records there in which 3
records are duplicate how will you find out those 3 records?
- 6 Answers
- 9331 Views
- I also Faced
- E-Mail Answers
Answer Posted / santosh kumar sarangi
select * from emp where empno in (select empno from emp
group by sal having count(*)>1)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
is it possible to index the data in cache of lkp transformation ?
What is data caches/ index caches?
what is the difference between informatica6.1 and infomatica7.1
Explain lookup transformation is active in informatica
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is sorter transformation?
How many transformations can be used in mapplets.
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
scenario where i can use only concurrent execution of workflow.
write a query to retrieve the latest records from the table sorted by version(scd)
What if the source is a flat-file?
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
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Why update strategy and union transformations are active? Explain with examples.
