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
What is data modeling and data mining?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
Explain about hash partitioning?
flat filevalidation in informatica
where are the log files generally stored.Can you change the path of the file.what can the path be?
what make u disappointmnets in u r career
Identifying the bottlenecks in various components of Informatica and resolving them.
SCD2 will work on only dimension tables as well as fact Table?
Can we create Hierarchies in generic datasources?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
how do u really know that paging to disk is happening while u are using a lookup transform?
How many steps etl contains explain with example?
What is staging area referring to?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
Explain etl?
