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 |
Identifying the bottlenecks in various components of Informatica and resolving them.
What is tracing level? How many types of transformations supported by sorted input?
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.
What is granularity? Please explain with example
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
dimension object created in oracle can be imported in designer?how?
Can there be sub steps of etl steps?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
Explain etl mapping sheets?
what are the different forms of normalization?
When do we analyze the tables?
Explain me ETL project architecture in Detail?