Interested to Buy Any Domain ? << Click Here >> for more details...
What is ROWID explain ?
- 2 Answers
- 4778 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 |
What is the difference between project backlog and product backlog?
What are the names of the layers in etl?
what do u do when DB time takes more?in sap bi
where are the log files generally stored.Can you change the path of the file.what can the path be?
how do u decide whether u need to do aggregations at database level or at Informatica level?
IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
Which type or t/s is used to convert rows into column & column into rows
Eliminating of duplicate records without using dynamic lookups
What is etl process? How many steps etl contains?
if u can't find what you are looking for in lookup table, how do you handle?
what happens if the info.server doesn't find the session parameter in the parameter file?
Teradata 
