Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Explain what is etl process? How many steps etl contains explain with example?
What is the difference between round-robin partitioning and hash partitioning?
What is tracing level? How many types of transformations supported by sorted input?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
how would u estimate the size of Lookup transform data and index cache?
what are the concerns of OLTP and DSS systems?
list and discuss two approaches for updation of target table in Informatica and how they are different.
Do we need an ETL tool? When do we go for the tools in the market?
Identifying the bottlenecks in various components of Informatica and resolving them.
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
what is the difference between cardinality and Nullability?
What are your responsibilities as an etl tester?
What are the three tiers in etl?
what is granularity in Data ware House?
