Interested to Buy Any Domain ? << Click Here >> for more details...
In a table, 4 person having same salary. How to get Third
person record only?
- 15 Answers
- 21517 Views
- I also Faced
- E-Mail Answers
Answer Posted / srikanth
id sal
101 1000
102 1000
103 1000
104 1000
select id, sal from emp where rownum<=3
minus
select id, sal from emp wwhere rownum<=2;
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What is the use of source qualifier?
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.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Briefly define reusable transformation?
How do you change a non-reusable transformation to reusable transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain the difference between mapping parameter and mapping variable?
Explain the use of aggregator cache file?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
how to load rows into fact table in data warehouse
What the difference is between a database, a data warehouse and a data mart?
How do you load only null records into target? Explain through mapping flow.
What is a stored procedure transformation?
What is sq transformation?
