Interested to Buy Any Domain ? << Click Here >> for more details...
In a table, 4 person having same salary. How to get Third
person record only?
- 15 Answers
- 21528 Views
- I also Faced
- E-Mail Answers
Answer Posted / gopi k
rownum is pseudo column, when query extracts rows rownum
will be appended to query. So where rownum = 3 condition is
a wrong one.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the cumulative sum and moving sum?
whats the logic to load the lower level of granularity of data to fact table.
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 deployment group?
What is rank transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What are some examples of informatica etl programs?
What is the commit type if you have a transaction control transformation in the mapping?
How do you load unique records into one target table and duplicate records into a different target table?
what is the size of u r source(like file or table)?
How union transformation is used?
What is the Rank index port in Rank transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
what is SDLC way of code development?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
