how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
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
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
how we can load rejected record's at run time?(not through bad files)
What are data-driven sessions?
According to his methodology what all you need before you build a datawarehouse
What is informatica worklet?
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
Explain sessions. Explain how batches are used to combine executions?
What is domain in terms of informatica?
How can you increase the performance in joiner transformation?
Explain the features of connected and unconnected lookup.
How to extract sap data using informatica? What is abap? What are idocs?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Define update strategy?
what is diff b/t sorter t/r and agg have the option sorter property...
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?