Interested to Buy Any Domain ? << Click Here >> for more details...
how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
- 16 Answers
- 25877 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / siva reddy
display odd records
select * from emp where (rowid,1) in ( select
rowid,mod(rownum,2) from emp)
display even records
select * from emp where (rowid,0) in ( select
rowid,mod(rownum,2) from emp)
| Is This Answer Correct ? | 10 Yes | 5 No |
Post New Answer View All Answers
Explain what transformation and how many are there in informatica?
What is the way to execute pl/sql script using informatica mapping?
What are the informatica performance improvement tips
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
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is Cognos script editor?
How will the document be delivered to me?
What is session task and command task?
Explain sessions and how many types of sessions are there?
generate date / time dimension in informatica
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
EXL informatica Questions
What is meant by query override?
where to store informatica rejected data?
Explain about cumulative Sum or moving sum?
