What is ROWID explain ?
Answers were Sorted based on User's Feedback
Answer / kishor potu
ROWID is the pesudo column the oracle it can create in built. it is the hexa decimal data type(it contain alpha numaric number). it contain length is 18 digits. there ROWID in a table must be unique. if you drop the row the ROWID will remove. if any new record enter into the table ROWID assigns a unique number that record.
if you want to see the rowid
select rowid from table_name;
| Is This Answer Correct ? | 2 Yes | 0 No |
ROWID is the physical location of a row. Consequently it is the fastest way of locating a row
| Is This Answer Correct ? | 2 Yes | 1 No |
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
List few etl bugs?
What is partitioning? Explain about round-robin, hash partitioning.
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
What are your responsibilities as an etl tester?
Difference between flat files and relational sources?
what is the difference between OLTP database and data warehousing database?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
When do we go for the tools in the market?