No subject


Wed Nov 1 14:58:42 MST 2017


ata will load.

We have an instance where we have data count diffs between two tables.   On=
ly 2.4 billion rows of 4 billion were loaded.

Is the disable RI check discarding rows which violate FK constraints and no=
t loading all rows as we were lead to believe?

IF so then would dropping all constraints, loading data, setting disable RI=
 =E2=80=98on=E2=80=99 then recreating the constraints be the way to get aro=
und this?

Thanks
David


This message may contain information that is confidential or privileged. If=
 you are not the intended recipient, please advise the sender immediately a=
nd delete this message. See http://www.blackrock.com/corporate/en-us/compli=
ance/email-disclaimers for further information.  Please refer to http://www=
.blackrock.com/corporate/en-us/compliance/privacy-policy for more informati=
on about BlackRock=E2=80=99s Privacy Policy.
For a list of BlackRock's office addresses worldwide, see http://www.blackr=
ock.com/corporate/en-us/about-us/contacts-locations.

=C2=A9 2017 BlackRock, Inc. All rights reserved.

--_000_097b09542b43435d99f87f93f6c1df56blackrockcom_
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<HTML xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<HEAD><!-- Template generated by Exclaimer Mail Disclaimers on 10:16:54 Mon=
day, 13 November 2017 -->
<STYLE type=3Dtext/css>P.ImprintUniqueID {
	MARGIN: 0cm 0cm 0pt
}
LI.ImprintUniqueID {
	MARGIN: 0cm 0cm 0pt
}
DIV.ImprintUniqueID {
	MARGIN: 0cm 0cm 0pt
}
TABLE.ImprintUniqueIDTable {
	MARGIN: 0cm 0cm 0pt
}
DIV.Section1 {
	page: Section1
}
</STYLE>
<!-- Template generated by Exclaimer Mail Disclaimers on 10:16:54 Monday, 1=
3 November 2017 -->
<STYLE type=3Dtext/css>P.ImprintUniqueID {
	MARGIN: 0cm 0cm 0pt
}
LI.ImprintUniqueID {
	MARGIN: 0cm 0cm 0pt
}
DIV.ImprintUniqueID {
	MARGIN: 0cm 0cm 0pt
}
TABLE.ImprintUniqueIDTable {
	MARGIN: 0cm 0cm 0pt
}
DIV.Section1 {
	page: Section1
}
</STYLE>

<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dutf-8" />
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)" />
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:10.0pt;
	font-family:"Arial",sans-serif;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#0079C1;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:#009A3D;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Arial",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Arial",sans-serif;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</HEAD>


<BODY lang=3D"EN-US" link=3D"#0079C1" vlink=3D"#009A3D">
<P class=3DImprintUniqueID>
<P class=3DImprintUniqueID>
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span style=3Dfont-size:11.0pt>We are doing a conver=
sion from solaris to linux and before we run our load table we disable_RK_c=
heck=3D&#8217;on&#8217; so we don&#8217;t run into constraint violations. (=
 we decided to create all constaints prior to our data
 loads)<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3Dfont-size:11.0pt><o:p>&nbsp;</o:p></sp=
an></p>
<p class=3D"MsoNormal"><span style=3Dfont-size:11.0pt>From what we were tol=
d this will &#8216;disable RI checking and
<b>all</b> the data will load.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3Dfont-size:11.0pt><o:p>&nbsp;</o:p></sp=
an></p>
<p class=3D"MsoNormal"><span style=3Dfont-size:11.0pt>We have an instance w=
here we have data count diffs between two tables.&nbsp;&nbsp; Only 2.4 bill=
ion rows of 4 billion were loaded.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3Dfont-size:11.0pt><o:p>&nbsp;</o:p></sp=
an></p>
<p class=3D"MsoNormal"><span style=3Dfont-size:11.0pt>Is the disable RI che=
ck discarding rows which violate FK constraints and not loading all rows as=
 we were lead to believe?<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3Dfont-size:11.0pt><o:p>&nbsp;</o:p></sp=
an></p>
<p class=3D"MsoNormal"><span style=3Dfont-size:11.0pt>IF so then would drop=
ping all constraints, loading data, setting disable RI &#8216;on&#8217; the=
n recreating the constraints be the way to get around this?<o:p></o:p></spa=
n></p>
<p class=3D"MsoNormal"><span style=3Dfont-size:11.0pt><o:p>&nbsp;</o:p></sp=
an></p>
<p class=3D"MsoNormal"><span style=3Dfont-size:11.0pt>Thanks<o:p></o:p></sp=
an></p>
<p class=3D"MsoNormal"><span style=3Dfont-size:11.0pt>David<o:p></o:p></spa=
n></p>
<p class=3D"MsoNormal"><span style=3Dfont-size:11.0pt><o:p>&nbsp;</o:p></sp=
an></p>
</div>
<FONT size=3D2 face=3DArial></FONT></P><FONT size=3D2 face=3DArial>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><SPAN lang=3DEN-GB style=
=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN>&nbsp;</P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><SPAN lang=3DEN-GB style=
=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">This message may contain informati=
on=20
that is confidential or privileged. If you are not the intended recipient,=
=20
please advise the sender immediately and delete this message. See <A href=
=3D"http://www.blackrock.com/corporate/en-us/compliance/email-disclaimers">=
http://www.blackrock.com/corporate/en-us/compliance/email-disclaimers</A>=20
for further information.&nbsp; Please refer to <A href=3D"http://www.blackr=
ock.com/corporate/en-us/compliance/privacy-policy">http://www.blackrock.com=
/corporate/en-us/compliance/privacy-policy</A>&nbsp;for=20
more information about BlackRock=E2=80=99s Privacy=20
Policy.</SPAN></P></FONT></P></FONT><FONT size=3D2 face=3DArial></FONT></P>=
<FONT size=3D2 face=3DArial>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><SPAN lang=3DEN-GB style=
=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">For a list of BlackRock's office=20
addresses worldwide, see <A href=3D"http://www.blackrock.com/corporate/en-u=
s/about-us/contacts-locations">http://www.blackrock.com/corporate/en-us/abo=
ut-us/contacts-locations</A>.<BR/><BR/><SPAN lang=3DEN-GB style=3D'FONT-SIZ=
E: 10pt; FONT-FAMILY: "Arial","sans-serif"; mso-fareast-font-family: Arial;=
 mso-fareast-theme-font: minor-latin; mso-bidi-font-family: "Times New Roma=
n"; mso-ansi-language: EN-GB; mso-fareast-language: EN-US; mso-bidi-languag=
e: AR-SA'>=C2=A9=20
</SPAN>2017 BlackRock, Inc. All rights reserved.</SPAN></P></FONT>
<P></P></FONT></BODY>
</HTML>



--_000_097b09542b43435d99f87f93f6c1df56blackrockcom_--


More information about the IQUG mailing list