how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
Answer Posted / punyaslok
(select * from emp)-(select rownum,emp.* from emp order by
mod(rownum,2);
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
what is the complex transformation you used in informatica
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How do you use reject loader.
What are the different versions of informatica?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Differentiate between reusable transformation and mapplet.
Explain the pipeline partition with real time example?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
can we override a native sql query within informatica? How do we do it?
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?
Explain the different dimensions.
difference between repository database and repository service?
How to do unit testing in informatica?
Different sorts of metadata that stores in the storage facility?
How do you load only null records into target? Explain through mapping flow.