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
- 6959 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to elaborate powercenter integration service?
What are the differences between a connected lookup and unconnected lookup?
Explain the tuning lookup transformation - informatica
Why do we need informatica?
Write the prerequisite tasks to achieve the session partition?
explain abt ur project architecture?
What is DR strategy for Informatica project?
If informatica has its scheduler why using third party scheduler?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
Can we create a node as a gateway node and the same node can be assigned to a grid?
Can we change Dynamic to Static or Persistent cache? If so what happens?
State the limitations where we cannot use joiner in the mapping pipeline?
I have a flat file, want to reverse the contents of the flat file
What is the fact table?
What is a predefined event?
