What is the query to find nth highest salary?
What is the use of cursors?
Answer Posted / sree
select sal from emp e where nth=(select count(*) from emp
where sal>e.sal);
| Is This Answer Correct ? | 5 Yes | 12 No |
Post New Answer View All Answers
What are the types of lookup transformation?
Write the program through which the records can be updated?
According to his methodology what all you need before you build a datawarehouse
How union transformation is used?
What are active transformations.
Mention few advantages of router transformation over filter transformation.
Why do you use Mapping Parameter and mapping variable?
Explain dynamic target flat file name generation in informatica
Can we create a Integration service without a Repository service and vice versa?
What are the advantages of informatica?
Plz can any one say me how to get the informatica certification materials and dumps
EXL informatica Questions
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is a sequence generator transformation?
COM components can be used in Informatica