Tell me one complex query in oracle ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / mahaboob basha
select users.user_id, users.email, max(classified_ads.posted)
from users, classified_ads
where users.user_id = classified_ads.user_id
group by users.user_id, users.email
order by upper(users.email);
Is This Answer Correct ? | 0 Yes | 4 No |
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
According to his methodology what all you need before you build a datawarehouse
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
What are the different types of code pages available in informatica & how to implement it in your project?
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15
Filter transformation in the condition one of the data is NULL would the record be dropped.
What is DTM process?
How we can confirm all mappings in the repository simultaneously?
how to join the two flatfiles using the joiner t/r if there is no matching port?