What information can you find in SYSIBM.SYSLINKS table ?
The SYSIBM.SYSLINKS table contains information about the links between tables created by referential constraints.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is implied Join. Where do we find it ? 03.11.08
Join between two Tables. Join Object defines The Relationship Between a Bc and atable.Join allows Bc to get Column from table rather then basetable. I...What is hybrid slowly changing dimension? 22.09.08
Let me give an example to make the point clear.... Like account information is usually maintained in two categories: Current Account and other is Time of...What is the need of surrogate key;why primary key not used as surrogate key Surrogate key is system generated unique number ? 22.09.08
Identity in SQL, Sequence in Oracle, Sequence Generator in Informatica. For Example : You are extracting Customer Information from OLTP Source and after ETL...what is junk dimension? what is the difference between junk dimension and degenerated dimension? 20.09.08
Junk dimension: Grouping of Random flags and text Attributes in a dimension and moving them to a separate sub dimension. Degenerate Dimension: Keeping the co...DDDAudit what is it ? 12.08.08
DDD Audit is a SQR used to find the inconsistencies between the data structures defined in PeopleTools table against the underlying database. SYS Audit is an...What information is held in SYSIBM.SYSCOPY ? 12.03.08
The SYSIBM.SYSCOPY table contains information about image copies made of the tablespaces....How do you find the tables to report from when the user just tell you the transaction he uses? And all the underlying data is from SAP structures? 13.04.07
Transaction code is entered in command field to open the table – Utilities – Table contents display....Which are the three types of routing tables ? 15.02.07
The three types of routing tables are fixed, dynamic, and fixed central. The fixed table must be manually modified every time there is a change. A dynamic table...What is Metadata and why should I use it? 22.10.06
Metadata (’data about data’) is information about one of two things: Database information (java.sql.DatabaseMetaData), or Information about a specific Resul...What does level of Granularity of a fact table signify? 17.03.06
Granularity The first step in designing a fact table is to determine the granularity of the fact table. By granularity, we mean the lowest level of information...