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

What is Data Vault???

0 Answers  

---

what is the difference between shortcut of an object and copy of an object? compare them?

1 Answers  

---

What is etl process?

0 Answers  

---

we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record

3 Answers  

---

When do we analyze the tables? How do we do it?

0 Answers  

---

we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??

1 Answers  

---

How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)

1 Answers  

---

When do we analyze the tables?

0 Answers  

---

where are the log files generally stored.Can you change the path of the file.what can the path be?

0 Answers  

---

How we can see table structure?

2 Answers   iGate,

---

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

0 Answers  

---

what are the concerns of OLTP and DSS systems?

0 Answers   TCS,

---