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 does the server recongnise the source and target databases.Elaborate on this
what is a worklet?
Which transformation we use to convert 'NA' to 'Not Available'
what is the use of structures?how many nodes can u create in a structure?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
Explain me ETL project architecture in Detail?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
What are dimensions?
Is apache nifi an etl tool?
How etl testing is different from database testing?
What is abap? What are idocs?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
What is data modeling and data mining?
how would u estimate the size of Aggregator transform data and index cache?
Give the benefits of data integration suite?