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;

Answer / pullagura8

ROWID is the physical location of a row. Consequently it is the fastest way of locating a row

without using ETL tool can u prepare a Data warehousing and maintaining?

3 Answers  

---

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

0 Answers  

---

Mention few test cases and explain them?

0 Answers  

---

Explain do we need an etl tool?

0 Answers  

---

Need Informatica Power Center 9.1 free download(for all windows version)

1 Answers   ABC,

---

What are the different etl testing categories as per their function?

0 Answers  

---

what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?

1 Answers  

---

What is the main difference between peek stage and copy stage

2 Answers  

---

What are the differences between sql override and update override?

0 Answers  

---

Hi, Lookup() is what kind of join ?

6 Answers   Satyam,

---

Is apache nifi an etl tool?

0 Answers  

---

Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10

0 Answers   Cap Gemini,

---