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
how do use session mapping parameters ?(in which transformation)
explain the methodology of Data Warehousing?(Polaries)
Can anyone explain me a scenario from banking and finance...more precisely a mapping
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.
What is a staging area? What is the purpose of a staging area?
How many types of transformations supported by sorted input?
how do u implement configuration management in Informatica?
Mention few test cases and explain them?
Explain about round-robi?
SCD2 will work on only dimension tables as well as fact Table?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
what are the reports developed in sap bw project and what is the requirement for developing it?
Difference between flat files and relational sources?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
What is a lookup table in etl?