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
- 25430 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / kondeti srinivas
select * from emp where (rowid,1) in (select rowid,mod(rownum,2) from emp where rownum<=5)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is the size of u r source(like file or table)?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is the difference between STOP and ABORT options in Workflow Monitor?
What are the differences between joiner transformation and source qualifier transformation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What are mapplets? How is it different from a Reusable Transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Differentiate between source qualifier and filter transformation?
What is meant by query override?
What is union transformation in informatica?
scenario where i can use only concurrent execution of workflow.
In which transformation you cannot drag ports into it?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
In informatics server which files are created during the session rums?
