Interested to Buy Any Domain ? << Click Here >> for more details...
What is ROWID explain ?
- 2 Answers
- 4654 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
what is HISTOGRAM? how to generate statistics?
Can we create Hierarchies in generic datasources?
When do we analyze the tables? How do we do it?
How etl testing is different from database testing?
what is the difference between OLTP database and data warehousing database?
Can u access a repository created in previous version of Informatica?
What is Relational Integrity?
What are snapshots?
What are the different etl testing categories as per their function?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
Teradata 
