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 |
what is update strategy transformation ?
What is the function of union transformation?
What is an Integration service in Informatica?
What are some examples of informatica etl programs?
What is ThroughPut in Informatica, How it works, Where I can find this option to check ?
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
can we generate reports in informatica ? How?
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..