Interested to Buy Any Domain ? << Click Here >> for more details...
How to display last 5 records in a table ?
With out Top key word and doing order by desc
Advance thanks
- 2 Answers
- 6820 Views
- Puma, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / madhu
this is can acheieve by following query
select * from(select rowunum r,e.*from emp e) where
r>(select count(*)-5 from emp);
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / priyank
select * from emp
minus
select * from emp where rownum <= (select max(rownum)-5
from emp)
| Is This Answer Correct ? | 1 Yes | 0 No |
Why is sorter an active transformation?
Can yoU use the maping parameters or variables created in one maping into another maping?
What are Target Options on the Servers?
what is the logic will you implement to load data into a fact table from n dimension tables?
can you use flat file for repository?why?
What are mapplets?
 Informatica Checkpoints
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
State the limitations where we cannot use joiner in the mapping pipeline?
Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks
Teradata 
