Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / prateek
select distinct sal from emp e1 where 3 = (select count(distinct sal) from emp e2 where e1.sal <= e2.sal);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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
how to load rows into fact table in data warehouse
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How you know when to use a static cache and dynamic cache in lookup transformation?
What is sq transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Mention few power centre client applications with their basic purpose?
What is a dimensional model?
What is joiner transformation?
What is dynamic cache?
How to partition the Session?
What is session task and command task?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How to load the data from a flat file into the target where the source flat file name changes daily?
