What is ROWID explain ?
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 |
how do u extract data from different data sources explain with an example?
can cubes contain measures ?
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
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
What is a mapping, session, worklet, workflow, mapplet?
how do u really know that paging to disk is happening while u are using a lookup transform?
What exact we can see in table?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
Which transformation we use to convert 'NA' to 'Not Available'
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
Do we need an ETL tool? When do we go for the tools in the market?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you