Semi Zone: Data Ware Housing

IBM Infosphere Data stage 8.1 Notes | Examples | Real Time Scenario's

<div dir="ltr" style="text-align: left;" trbidi="on"><h2 itemprop="name"><strong><span style="color: red; font-size: small;"><st1:stockticker w:st="on">IBM</st1:stockticker> Infosphere Data stage 8.1 Notes & Examples & Real Time Scenario's</span></strong><br /><br /><strong>Concepts</strong><br /><strong><br /></strong>*  <a data-cke-saved-href="http://foryooth.blogspot.in/2014/01/ibm-info-sphere-datastage-tutorial.html" href="http://foryooth.blogspot.in/2014/01/ibm-info-sphere-datastage-tutorial.html" target="_blank">Introductionabout Data stage</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2014/01/difference-between-server-jobs-and.html" href="http://foryooth.blogspot.in/2014/01/difference-between-server-jobs-and.html" target="_blank">Difference between server jobs and Parallel jobs</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2014/01/pipeline-partition-parallelism-in-ibm.html" href="http://foryooth.blogspot.in/2014/01/pipeline-partition-parallelism-in-ibm.html" target="_blank">Pipeline parallelism and Partition Parallelism</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2014/01/pipeline-partition-parallelism-in-ibm.html" href="http://foryooth.blogspot.in/2014/01/pipeline-partition-parallelism-in-ibm.html" target="_blank">Partition Techniques</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2014/01/ibm-info-sphere-datastage-configuration.html" href="http://foryooth.blogspot.in/2014/01/ibm-info-sphere-datastage-configuration.html" target="_blank">Configuration file</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2014/01/ibm-info-sphere-datastage-etl-tool.html" href="http://foryooth.blogspot.in/2014/01/ibm-info-sphere-datastage-etl-tool.html" target="_blank">Processing Environment</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/search?q=Data+Stage+Client+and+Server+Components" href="http://foryooth.blogspot.in/search?q=Data+Stage+Client+and+Server+Components" target="_blank">Data Stage Client and Server Components</a><br /><br /><strong>Data stage Designer</strong><br /><strong><br /></strong>* <a data-cke-saved-href="http://foryooth.blogspot.in/search?q=Data+stage+Designer" href="http://foryooth.blogspot.in/search?q=Data+stage+Designer" target="_blank">Introduction about Data stage Designer</a><br /><br />* <a data-cke-saved-href="http://foryooth.blogspot.in/search?q=Repository" href="http://foryooth.blogspot.in/search?q=Repository" target="_blank">Repository</a><br /><br />* <a data-cke-saved-href="http://foryooth.blogspot.in/search?q=Repository" href="http://foryooth.blogspot.in/search?q=Repository" target="_blank">Palatte</a><br /><br />* <a data-cke-saved-href="http://foryooth.blogspot.in/search?q=data+stage+full+notes" href="http://foryooth.blogspot.in/search?q=data+stage+full+notes" target="_blank">Types of Links</a><br /><br /><strong>File Stages</strong><br /><strong><br /></strong><div style="margin-left: 39pt;">*  <a data-cke-saved-href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" target="_blank">Sequential file</a></div><div style="margin-left: 39pt;"><br /></div><div style="margin-left: 39pt;">*  <a data-cke-saved-href="http://foryooth.blogspot.in/2014/01/dataset-stage-in-datastage-properties.html" href="http://foryooth.blogspot.in/2014/01/dataset-stage-in-datastage-properties.html" target="_blank">Data set</a></div><div style="margin-left: 39pt;"><br /></div><div style="margin-left: 39pt;">*  <a data-cke-saved-href="http://foryooth.blogspot.in/search?q=File+set" href="http://foryooth.blogspot.in/search?q=File+set" target="_blank">File set</a></div><div style="margin-left: 39pt;"><br /></div><div style="margin-left: 39pt;">*  <a data-cke-saved-href="http://foryooth.blogspot.in/2014/02/lookup-stage-in-data-stage-ibm-info.html" href="http://foryooth.blogspot.in/2014/02/lookup-stage-in-data-stage-ibm-info.html" target="_blank">Lookup file set</a></div><div style="margin-left: 39pt;"><br /></div><strong>Database Stages</strong><br /><strong><br /></strong>*  <a data-cke-saved-href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" target="_blank">Oracle Enterprise</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/search?q=ODBC+Enterprise" href="http://foryooth.blogspot.in/search?q=ODBC+Enterprise">ODBC Enterprise</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2013/12/example-jobs-for-dynamic-rdbms-in.html" href="http://foryooth.blogspot.in/2013/12/example-jobs-for-dynamic-rdbms-in.html" target="_blank">Dynamic RDBMS</a><br /><br /><strong>Processing Stages</strong><br /><strong><br /></strong>*  <a data-cke-saved-href="http://foryooth.blogspot.in/search?q=Aggregator" href="http://foryooth.blogspot.in/search?q=Aggregator" target="_blank">Aggregator</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" target="_blank">Change Apply</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" target="_blank">Change Capture</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" target="_blank">Compare</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" target="_blank">Compress</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2014/01/ibm-info-sphere-datastage-copy-stage-in.html" href="http://foryooth.blogspot.in/2014/01/ibm-info-sphere-datastage-copy-stage-in.html" target="_blank">Copy</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2013/12/dataage-81-notes-ecode-stage-decode.html" href="http://foryooth.blogspot.in/2013/12/dataage-81-notes-ecode-stage-decode.html" target="_blank">Decode</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2013/12/dataage-81-notes-ecode-stage-decode.html" href="http://foryooth.blogspot.in/2013/12/dataage-81-notes-ecode-stage-decode.html" target="_blank">Difference</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2013/12/dataage-81-notes-ecode-stage-decode.html" href="http://foryooth.blogspot.in/2013/12/dataage-81-notes-ecode-stage-decode.html" target="_blank">Encode</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" target="_blank">Expand</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/search?q=filter" href="http://foryooth.blogspot.in/search?q=filter" target="_blank">Filter</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/search?q=funnel" href="http://foryooth.blogspot.in/search?q=funnel" target="_blank">Funnel</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" target="_blank">Generic</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2014/02/join-stage-in-ibm-info-sphere-data_4.html" href="http://foryooth.blogspot.in/2014/02/join-stage-in-ibm-info-sphere-data_4.html" target="_blank">Join</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2014/02/lookup-stage-in-data-stage-ibm-info.html" href="http://foryooth.blogspot.in/2014/02/lookup-stage-in-data-stage-ibm-info.html" target="_blank">Look up</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2014/02/lookup-stage-in-data-stage-ibm-info.html" href="http://foryooth.blogspot.in/2014/02/lookup-stage-in-data-stage-ibm-info.html" target="_blank">Merge</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2014/01/modify-stage-in-ibm-info-sphere-data.html" href="http://foryooth.blogspot.in/2014/01/modify-stage-in-ibm-info-sphere-data.html" target="_blank">Modify</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/search?q=pivote" href="http://foryooth.blogspot.in/search?q=pivote" target="_blank">Pivote</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/search?q=Remove+Duplicate" href="http://foryooth.blogspot.in/search?q=Remove+Duplicate" target="_blank">Remove Duplicate</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2014/01/external-filter-stage-in-ibm-info.html" href="http://foryooth.blogspot.in/2014/01/external-filter-stage-in-ibm-info.html" target="_blank">External Filter</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/search?q=sort" href="http://foryooth.blogspot.in/search?q=sort" target="_blank">Sort</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/search?q=Surrogate+Key+Generator" href="http://foryooth.blogspot.in/search?q=Surrogate+Key+Generator" target="_blank">Surrogate Key Generator</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2014/01/switch-stage-in-ibm-info-sphere.html" href="http://foryooth.blogspot.in/2014/01/switch-stage-in-ibm-info-sphere.html" target="_blank">Switch</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/search?q=Transformer" href="http://foryooth.blogspot.in/search?q=Transformer" target="_blank">Transformer</a><br /><br /><strong><a data-cke-saved-href="http://foryooth.blogspot.in/2014/01/development-and-debug-stage-in-ibm-info.html" href="http://foryooth.blogspot.in/2014/01/development-and-debug-stage-in-ibm-info.html" target="_blank">Debugging Stages</a></strong><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2014/01/what-is-row-column-generator-stage.html" href="http://foryooth.blogspot.in/2014/01/what-is-row-column-generator-stage.html" target="_blank">Column Generator</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2014/01/what-is-head-stage-in-ibm-info-sphere.html" href="http://foryooth.blogspot.in/2014/01/what-is-head-stage-in-ibm-info-sphere.html" target="_blank">Head</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2014/01/what-is-peek-stage-tutorial-practice_27.html" href="http://foryooth.blogspot.in/2014/01/what-is-peek-stage-tutorial-practice_27.html" target="_blank">Peek</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2014/01/what-is-row-column-generator-stage.html" href="http://foryooth.blogspot.in/2014/01/what-is-row-column-generator-stage.html" target="_blank">Row Generator</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/search?q=Sample" href="http://foryooth.blogspot.in/search?q=Sample" target="_blank">Sample</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2014/01/what-is-tail-stage-tutorial-practice.html" href="http://foryooth.blogspot.in/2014/01/what-is-tail-stage-tutorial-practice.html" target="_blank">Tail</a><br /><br /><strong>Datastage Manager</strong><br /><strong><br /></strong>*  <a data-cke-saved-href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" target="_blank">Introduction about Data stage Manager</a><br /><br />*  <a data-cke-saved-href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" target="_blank">Importing the Jobs</a><br /><br />* <a data-cke-saved-href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" target="_blank"> Exporting the Jobs</a><br /><br /><br /><a href="http://foryooth.blogspot.in/search/label/Data%20stage%20practice%20bits" target="_blank"><span style="color: red;">Data Stage Practice Bits</span></a><br /><br /><span style="color: blue;"><a href="http://foryooth.blogspot.in/search/label/Data%20Ware%20Housing" target="_blank">Data Warehousing</a></span><br /><br /><span style="font-weight: normal;"><span style="font-size: small;"><br /></span></span><span style="font-weight: normal;"><span style="font-size: small;">ETL, ETL Data Stage, ETL Tool Data Stage, Data Stage, Data Stage Full Notes, IBM Infosphere Data Stage Full Notes, </span></span><span style="font-size: small; font-weight: normal;">IBM Infosphere Data Stage 8.1 & 8.5 & 8.7 Full Notes, IBM Infosphere Data Stage 8.1 & 8.5 & 8.7 Practice Bits, IBM Infosphere Data Stage 8.1 & 8.5 & 8.7 Realtime Scenario's, IBM Infosphere Data Stage 8.1 & 8.5 & 8.7 Examples, IBM Infosphere Data Stage 8.1 & 8.5 & 8.7 Tutorial, IBM Data Stage, Data Ware Housing Concepts, Data Ware Housing</span></h2></div>

IBM Infosphere Data stage 8.1 Notes | Examples | Real Time Scenario's

IBM Infosphere Data stage 8.1 Notes & Examples & Real Time Scenario's Concepts * Introductionabout Data stage * Difference ...

Data Warehousing Interview Questions || Informatica & IBM Info Sphere Data Stage Interview Questions

<div dir="ltr" style="text-align: left;" trbidi="on"><h3 style="text-align: left;"><span style="line-height: 18.399999618530273px;"><span style="color: blue;">Data Warehousing Interview Questions</span></span></h3><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12pt; line-height: 115%;"><br /></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12pt; line-height: 115%;">Here we are providing Data Ware Housing Interview Questions in this Page. This questions are very useful to Interview. In this page data warehousing Concepts, Data ware housing Interview Questions and Data Ware housing Basic are Explained Deeply. Large amount of data is stored in any target system o server is called data ware housing. The Data ware concepts for first mainly explained topics are Schema, Data ware house deep Explanation and Data mart topics are Explained.</span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12pt; line-height: 115%;"><br /></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12pt; line-height: 115%;">In this data Warehousing Interview Questions for We are providing Topics are IBM Info sphere Data stage Topics, Infomatica Topics and Stages are Explained deeply. This Data ware Housing Concepts and Data Warehousing Interview Questions are very useful to develop your technical Skills for ETL Tool developers.</span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: small;"><span style="line-height: 115%;">This Informatica Interview Questions are deeply explained for Search </span></span><span style="line-height: 18.399999618530273px;">users</span><span style="font-size: small;"><span style="line-height: 115%;">. here in this page proving topics are mainly Data Warehousing Interview Questions, Data Warehousing Concepts, Data Integration Questions and Informatica Interview questions, IBM Info Sphere Data Stage Interview Questions.</span></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;">Q : What is the difference between snow flake and star schema</span><o:p></o:p></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: blue;">Ans :</span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184;"> <tbody><tr>  <td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 230.95pt;" valign="top" width="308">  <div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Star Schema<o:p></o:p></span></b></div></td>  <td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 231.2pt;" valign="top" width="308">  <div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Snow Flake   Schema<o:p></o:p></span></b></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 230.95pt;" valign="top" width="308">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">The star   schema is the simplest data warehouse scheme.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 231.2pt;" valign="top" width="308">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Snowflake   schema is a more complex data warehouse model than a star schema.<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 230.95pt;" valign="top" width="308">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">In star   schema each of the dimensions is represented in a single table .It should not   have any hierarchies between dims.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 231.2pt;" valign="top" width="308">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">In snow flake   schema at least one hierarchy should exists between dimension tables.<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 230.95pt;" valign="top" width="308">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">It contains a   fact table surrounded by dimension tables. If the dimensions are   de-normalized, we say it is a star schema design.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 231.2pt;" valign="top" width="308">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">It contains a   fact table surrounded by dimension tables. If a dimension is normalized, we   say it is a snow flaked design.<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 230.95pt;" valign="top" width="308">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">In star   schema only one join establishes the relationship between the fact table and   any one of the dimension tables.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 231.2pt;" valign="top" width="308">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">In snow flake   schema since there is relationship between the dimensions tables it has to do   many joins to fetch the data.<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 230.95pt;" valign="top" width="308">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">A star schema   optimizes the performance by keeping queries simple and providing fast   response time. All the information about the each level is stored in one row.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 231.2pt;" valign="top" width="308">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Snowflake   schemas normalize dimensions to eliminated redundancy. The result is more   complex queries and reduced query performance.<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 230.95pt;" valign="top" width="308">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">It is called   a star schema because the diagram resembles a star.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 231.2pt;" valign="top" width="308">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">It is called   a snowflake schema because the diagram resembles a snowflake.<o:p></o:p></span></div></td> </tr></tbody></table><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><br /></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="color: red;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Q : </span></b><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Difference between data mart and data warehouse</span></b></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: blue;">Ans :</span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184;"> <tbody><tr>  <td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Data Mart<o:p></o:p></span></b></div></td>  <td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Data   Warehouse<o:p></o:p></span></b></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Data mart is   usually sponsored at the department level and developed with a specific issue   or subject in mind, a data mart is a data warehouse with a focused objective.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Data   warehouse is a “Subject-Oriented, Integrated, Time-Variant, Nonvolatile   collection of data in support of decision making”.<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">A data mart   is used on a business division/ department level.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">A data   warehouse is used on an enterprise level<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">A Data Mart   is a subset of data from a Data Warehouse. Data Marts are built for specific   user groups.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">A Data   Warehouse is simply an integrated consolidation of data from a variety of   sources that is specially designed to support strategic and tactical decision   making.<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">By providing   decision makers with only a subset of data from the Data Warehouse, Privacy,   Performance and Clarity Objectives can be attained.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">The main   objective of Data Warehouse is to provide an integrated environment and coherent   picture of the business at a point in time.<o:p></o:p></span></div></td> </tr></tbody></table><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;">Q : Differences between connected lookup and unconnected lookup ?</span><o:p></o:p></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: blue;">Ans :</span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184;"> <tbody><tr>  <td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 3.2in;" valign="top" width="307">  <div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Connected   Lookup<o:p></o:p></span></b></div></td>  <td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 231.75pt;" valign="top" width="309">  <div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Unconnected   Lookup<o:p></o:p></span></b></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 3.2in;" valign="top" width="307">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">This is   connected to pipleline and receives the input values from pipleline.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 231.75pt;" valign="top" width="309">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Which is not   connected to pipeline and receives input values from the result of a: LKP   expression in another transformation via arguments.<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 3.2in;" valign="top" width="307">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">We cannot use   this lookup more than once in a mapping.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 231.75pt;" valign="top" width="309">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">We can use   this transformation more than once within the mapping <o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 3.2in;" valign="top" width="307">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">We can return   multiple columns from the same row.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 231.75pt;" valign="top" width="309">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Designate one   return port (R), returns one column from each row.<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 3.2in;" valign="top" width="307">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">We can   configure to use dynamic cache.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 231.75pt;" valign="top" width="309">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">We cannot   configure to use dynamic cache.<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 3.2in;" valign="top" width="307">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Pass multiple   output values to another transformation. Link lookup/output ports to another   transformation.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 231.75pt;" valign="top" width="309">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Pass one   output value to another transformation. The lookup/output/return port passes   the value to the transformation calling: LKP expression.<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 3.2in;" valign="top" width="307">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Use a dynamic   or static cache<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 231.75pt;" valign="top" width="309">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Use a static   cache<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 3.2in;" valign="top" width="307">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Supports user   defined default values.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 231.75pt;" valign="top" width="309">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Does not   support user defined default values.<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 3.2in;" valign="top" width="307">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Cache   includes the lookup source column in the lookup condition and the lookup   source columns that are output ports.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 231.75pt;" valign="top" width="309">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Cache   includes all lookup/output ports in the lookup condition and the   lookup/return port.<o:p></o:p></span></div></td> </tr></tbody></table><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><br /></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;">Q : What is the difference between joiner and lookup ?</span><o:p></o:p></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: blue;">Ans :</span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184;"> <tbody><tr>  <td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Joiner<o:p></o:p></span></b></div></td>  <td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Lookup<o:p></o:p></span></b></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">In joiner on   multiple matches it will return all matching records.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">In lookup it   will return either first record or last record or any value or error value.<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">In joiner we   cannot configure to use persistence cache, shared cache, uncached and dynamic   cache<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Where as in   lookup we can configure to use persistence cache, shared cache, uncached and   dynamic cache.<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">We cannot   override the query in joiner<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">We can   override the query in lookup to fetch the data from multiple tables.<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">We can   perform outer join in joiner transformation.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">We cannot   perform outer join in lookup transformation.<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">We cannot use   relational operators in joiner transformation.(i.e. <,>,<= and so   on)<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Where as in   lookup we can use the relation operators. (i.e. <,>,<= and so on)<o:p></o:p></span></div></td> </tr></tbody></table><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><br /></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;">Q : What is the difference between source qualifier and lookup ?</span></span></b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;"><br /></span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: blue;">Ans </span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;"><br /></span></span></b></div><table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184;"> <tbody><tr>  <td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 230.8pt;" valign="top" width="308">  <div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Source   Qualifier<o:p></o:p></span></b></div></td>  <td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 231.35pt;" valign="top" width="308">  <div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Lookup<o:p></o:p></span></b></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 230.8pt;" valign="top" width="308">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">In source   qualifier it will push all the matching records.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 231.35pt;" valign="top" width="308">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Where as in   lookup we can restrict whether to display first value, last value or any   value<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 230.8pt;" valign="top" width="308">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">In source   qualifier there is no concept of cache.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 231.35pt;" valign="top" width="308">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Where as in   lookup we concentrate on cache concept.<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 230.8pt;" valign="top" width="308">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">When both   source and lookup are in same database we can use source qualifier.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 231.35pt;" valign="top" width="308">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">When the   source and lookup table exists in different database then we need to use   lookup.<o:p></o:p></span></div></td> </tr></tbody></table><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><br /></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;">Q : Differences between dynamic lookup and static lookup ?</span><o:p></o:p></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: blue;">Ans :</span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184;"> <tbody><tr>  <td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Dynamic   Lookup Cache<o:p></o:p></span></b></div></td>  <td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Static Lookup   Cache<o:p></o:p></span></b></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">In dynamic   lookup the cache memory will get refreshed as soon as the record get inserted   or updated/deleted in the lookup table.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">In static   lookup the cache memory will not get refreshed even though record inserted or   updated in the lookup table it will refresh only in the next session run.<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">When we   configure a lookup transformation to use a dynamic lookup cache, you can only   use the equality operator in the lookup condition.<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">NewLookupRow   port will enable automatically.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">It is a   default cache.<o:p></o:p></span></div></td> </tr><tr>  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">Best example   where we need to use dynamic cache is if suppose first record and last record   both are same but there is a change in the address. What informatica mapping   has to do here is first record needs to get insert and last record should get   update in the target table.<o:p></o:p></span></div></td>  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 239.4pt;" valign="top" width="319">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">If we use   static lookup first record it will go to lookup and check in the lookup cache   based on the condition it will not find the match so it will return null   value then in the router it will send that record to insert flow.<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">But still   this record dose not available in the cache memory so when the last record   comes to lookup it will check in the cache it will not find the match so it   returns null value again it will go to insert flow through router but it is   suppose to go to update flow because cache didn’t get refreshed when the   first record get inserted into target table.<o:p></o:p></span></div></td> </tr></tbody></table><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><br /></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;"><br /></span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="line-height: 18.399999618530273px;"><b><span style="color: blue;">Informatica & IBM Info Sphere Data Stage Interview Questions</span></b></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;"><br /></span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;">Q : How  to Process multiple flat files to single target table through informatica if all files are same structure?</span><o:p></o:p></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: blue;">Ans :</span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: blue;"><br /></span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">We can process all flat files through one mapping and one session using list file.<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">First we need to create list file using unix script  for all flat file the extension of the list file is .LST.<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">This list file it will have only flat file names.<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">At session  level  we need to set <o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">source file directory  as <b>list file path</b><o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">And source file name as <b>list file name</b><o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">And file type as <b>indirect.</b><o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><b><br /></b></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><b><br /></b></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;">Q : SCD Type-II Effective-Date Approach ?</span><o:p></o:p></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: blue;">Ans :</span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoListParagraphCxSpFirst" style="mso-list: l8 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">We have one of the dimension in current project called resource dimension. Here we are maintaining the history to keep track of SCD changes.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l8 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">To maintain the history in slowly changing dimension or resource dimension. We followed SCD Type-II Effective-Date approach.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l8 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">My resource dimension structure would be eff-start-date, eff-end-date, s.k and source columns.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l8 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Whenever I do a insert into dimension I would populate eff-start-date with sysdate, eff-end-date with future date and s.k as a sequence number.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l8 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">If the record already present in my dimension but there is change in the source data. In that case what I need to do is<o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="mso-list: l8 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Update the previous record eff-end-date with sysdate and insert as a new record with source data.<o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="mso-list: l8 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;">Q : Informatica design to implement SDC Type-II effective-date approach?</span><o:p></o:p></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: blue;">Ans :</span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoListParagraphCxSpFirst" style="mso-list: l5 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Once you fetch the record from source qualifier. We will send it to lookup to find out whether the record is present in the target or not based on source primary key column.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l5 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Once we find the match in the lookup we are taking SCD column and s.k column from lookup to expression transformation.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l5 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">In lookup transformation we need to override the lookup override query to fetch active records from the dimension while building the cache.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l5 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">In expression transformation I can compare source with lookup return data.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l5 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">If the source and target data is same then I can make a flag as ‘S’.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l5 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">If the source and target data is different then I can make a flag as ‘U’.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l5 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">If source data does not exists in the target that means lookup returns null value. I can flag it as ‘I’.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l5 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Based on the flag values in router I can route the data into insert and update flow.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l5 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">If flag=’I’ or ‘U’ I will pass it to insert flow.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l5 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">If flag=’U’ I will pass this record to eff-date update flow<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l5 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">When we do insert we are passing the sequence value to s.k.<o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="mso-list: l5 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Whenever we do update we are updating the eff-end-date column based on lookup return s.k value.<o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="mso-list: l5 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></div><div class="MsoListParagraphCxSpLast" style="mso-list: l5 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;">Q : Complex Mapping</span><o:p></o:p></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;"><br /></span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: blue;">Ans :</span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;"><br /></span></span></b></div><div class="MsoListParagraphCxSpFirst" style="mso-list: l11 level1 lfo7; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">We have one of the order file requirement. Requirement is every day in source system they will place filename with timestamp in informatica server.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l11 level1 lfo7; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">We have to process the same date file through informatica.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l11 level1 lfo7; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Source file directory contain older than 30 days files with timestamps.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l11 level1 lfo7; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">For this requirement if I hardcode the timestamp for source file name it will process the same file every day.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l11 level1 lfo7; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">So what I did here is I created $InputFilename for source file name.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l11 level1 lfo7; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Then I am going to use the parameter file to supply the values to session variables ($InputFilename).<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l11 level1 lfo7; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">To update this parameter file I have created one more mapping.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l11 level1 lfo7; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">This mapping will update the parameter file with appended timestamp to file name.<o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="mso-list: l11 level1 lfo7; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">I make sure to run this parameter file update mapping before my actual mapping.<o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="mso-list: l11 level1 lfo7; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></div><div class="MsoListParagraphCxSpLast" style="mso-list: l11 level1 lfo7; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;">Q : How to handle errors in informatica?</span><o:p></o:p></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: blue;">Ans :</span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoListParagraphCxSpFirst" style="mso-list: l10 level1 lfo8; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">We have one of the source with numerator and denominator values we need to calculate num/deno<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l10 level1 lfo8; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">When populating to target.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l10 level1 lfo8; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">If deno=0 I should not load this record into target table.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l10 level1 lfo8; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">We need to send those records to flat file after completion of 1<sup>st</sup> session run. Shell script will check the file size.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l10 level1 lfo8; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">If the file size is greater than zero then it will send email notification to source system POC (point of contact) along with deno zero record file and appropriate email subject and body.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l10 level1 lfo8; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">If file size<=0 that means there is no records in flat file. In this case shell script will not send any email notification.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l10 level1 lfo8; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Or<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l10 level1 lfo8; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">We are expecting a not null value for one of the source column.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l10 level1 lfo8; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">If it is null that means it is a error record.<o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="mso-list: l10 level1 lfo8; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">We can use the above approach for error handling.<o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="mso-list: l10 level1 lfo8; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></div><div class="MsoListParagraphCxSpLast" style="mso-list: l10 level1 lfo8; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;">Q : Worklet</span><o:p></o:p></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: blue;">Ans :</span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Worklet is a set of reusable sessions. We cannot run the worklet without workflow.<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">If we want to run 2 workflow one after another.<o:p></o:p></span></div><div class="MsoListParagraphCxSpFirst" style="mso-list: l3 level1 lfo10; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">If both workflow exists in same folder we can create 2 worklet rather than creating 2 workfolws.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l3 level1 lfo10; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Finally we can call these 2 worklets in one workflow.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l3 level1 lfo10; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">There we can set the dependency.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l3 level1 lfo10; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">If both workflows exists in different folders or repository then we cannot create worklet.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l3 level1 lfo10; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">We can set the dependency between these two workflow using shell script is one approach.<o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="mso-list: l3 level1 lfo10; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">The other approach is event wait and event rise.<o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="mso-list: l3 level1 lfo10; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;">Q : In shell script approach</span><o:p></o:p></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: blue;">Ans :</span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoListParagraphCxSpFirst" style="mso-list: l2 level1 lfo9; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">As soon as it completes first workflow we are creating zero byte file (indicator file).<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l2 level1 lfo9; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">If indicator file is available in particular location. We will run second workflow.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="mso-list: l2 level1 lfo9; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">If indicator file is not available we will wait for 5 minutes and again we will check for the indicator. Like this we will continue the loop for 5 times i.e 30 minutes.<o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="mso-list: l2 level1 lfo9; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">After 30 minutes if the file does not exists we will send out email notification.<o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="mso-list: l2 level1 lfo9; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Event wait and Event rise approach<o:p></o:p></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">In event wait it will wait for infinite time. Till the indicator file is available.<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><br /></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><span style="line-height: 18.399999618530273px;"><b><span style="color: #660000;">Informatica & IBM Info Sphere Data Stage Interview Questions</span></b></span></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><br /></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;">Q : Why we need source qualifier?</span><o:p></o:p></span></b></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;"><br /></span></span></b></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: blue;">Ans :</span></span></b></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;"><br /></span></span></b></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Simply it performs select statement.<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Select statement fetches the data in the form of row.<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Source qualifier will select the data from the source table.<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">It identifies the record from the source.<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><br /></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Parameter file</span></b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">it will supply the values to session level variables and mapping level variables.<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Variables are of two types:<o:p></o:p></span></b></div><div class="MsoListParagraphCxSpFirst" style="mso-list: l1 level1 lfo3; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Session level variables<o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="mso-list: l1 level1 lfo3; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Mapping level variables<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><br /></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Session level variables are of four types:<o:p></o:p></span></b></div><div class="MsoListParagraphCxSpFirst" style="margin-bottom: .0001pt; margin-bottom: 0in; mso-add-space: auto; mso-list: l7 level1 lfo5; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">$DBConnection_Source<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: .0001pt; margin-bottom: 0in; mso-add-space: auto; mso-list: l7 level1 lfo5; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">$DBConnection_Target<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: .0001pt; margin-bottom: 0in; mso-add-space: auto; mso-list: l7 level1 lfo5; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">$InputFile<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: .0001pt; margin-bottom: 0in; mso-add-space: auto; mso-list: l7 level1 lfo5; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">$OutputFile<o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="margin-bottom: .0001pt; margin-bottom: 0in; mso-add-space: auto; text-align: justify; text-justify: inter-ideograph;"><br /></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Mapping level variables are of two types:<o:p></o:p></span></b></div><div class="MsoListParagraphCxSpFirst" style="mso-list: l4 level1 lfo4; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Variable<o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="mso-list: l4 level1 lfo4; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Parameter <o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="mso-list: l4 level1 lfo4; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></div><div class="MsoListParagraphCxSpLast" style="mso-list: l4 level1 lfo4; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;">Q : What is the difference between mapping level and session level variables?</span><o:p></o:p></span></b></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: blue;">Ans :</span></span></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Mapping level variables always starts with $$.<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">A session level variable always starts with $.<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><br /></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;">Q : Flat File</span><o:p></o:p></span></b></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;"><br /></span></span></b></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: blue;">Ans :</span></span></b></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;"><br /></span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Flat file is a collection of data in a file in the specific format.<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Informatica can support two types of files<o:p></o:p></span></div><div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo6; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Delimiter<o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="mso-list: l0 level1 lfo6; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">         </span></span><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Fixed Width<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">In delimiter we need to specify the separator.<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">In fixed width we need to known about the format first. Means how many character to read for particular column.<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">In delimiter also it is necessary to know about the structure of the delimiter. Because to know about the headers.<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">If the file contains the header then in definition we need to skip the first row.<b><o:p></o:p></b></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">List file:<o:p></o:p></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">If you want to process multiple files with same structure. We don’t need multiple mapping and multiple sessions.<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">We can use one mapping one session using list file option.<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">First we need to create the list file for all the files. Then we can use this file in the main mapping.<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;"><br /></span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;">Q : Aggregator Transformation:</span><o:p></o:p></span></b></div><div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><b><span style="font-size: 12pt;"><br /></span></b></div><div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><b><span style="font-size: 12pt;">Transformation type:</span></b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Active<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 5pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Connected<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">The Aggregator transformation performs aggregate calculations, such as averages and sums. The Aggregator transformation is unlike the Expression transformation, in that you use the Aggregator transformation to perform calculations on groups. The Expression transformation permits you to perform calculations on a row-by-row basis only.<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Components of the Aggregator Transformation:<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">The Aggregator is an active transformation, changing the number of rows in the pipeline. The Aggregator transformation has the following components and options<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Aggregate cache:</span></b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"> The Integration Service stores data in the aggregate cache until it completes aggregate calculations. It stores group values in an index cache and row data in the data cache.<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Aggregate expression:</span></b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"> Enter an expression in an output port. The expression can include non-aggregate expressions and conditional clauses.<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Group by port:</span></b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"> Indicate how to create groups. The port can be any input, input/output, output, or variable port. When grouping data, the Aggregator transformation outputs the last row of each group unless otherwise specified.<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Sorted input:</span></b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"> Select this option to improve session performance. To use sorted input, you must pass data to the Aggregator transformation sorted by group by port, in ascending or descending order.<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;">Q : Aggregate Expressions:</span></span></b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;"><br /></span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: blue;">Ans :</span></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;"><br /></span></span></b></div><div class="body" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">The Designer allows aggregate expressions only in the Aggregator transformation. An aggregate expression can include conditional clauses and non-aggregate functions. It can also include one aggregate function nested within another aggregate function, such as:<o:p></o:p></span></div><div class="codelast" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">MAX (COUNT (ITEM))<o:p></o:p></span></div><div class="body" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">The result of an aggregate expression varies depending on the group by ports used in the transformation<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><span style="color: red;"><br /></span></span></b></div><div class="MsoNormal" style="text-align: justify;"><b><span style="color: #20124d;">Informatica & IBM Info Sphere Data Stage Interview Questions</span></b></div><div class="MsoNormal" style="text-align: justify;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><span style="color: red;"><br /></span></span></b></div><div class="MsoNormal" style="text-align: justify;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><span style="color: red;">Q : Aggregate Functions</span><o:p></o:p></span></b></div><div class="MsoNormal" style="text-align: justify;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><span style="color: blue;"><br /></span></span></b></div><div class="MsoNormal" style="text-align: justify;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><span style="color: blue;">Ans : </span></span></b></div><div class="MsoNormal" style="text-align: justify;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><span style="color: blue;"><br /></span></span></b></div><div class="MsoNormal" style="text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Use the following aggregate functions within an Aggregator transformation. You can nest one aggregate function within another aggregate function.<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">The transformation language includes the following aggregate functions:<o:p></o:p></span></div><table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable"> <tbody><tr>  <td style="padding: 0in 0in 0in 0in;" valign="bottom">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><v:shapetype coordsize="21600,21600" filled="f" id="_x0000_t75" o:preferrelative="t" o:spt="75" path="m@4@5l@4@11@9@11@9@5xe" stroked="f">   <v:stroke joinstyle="miter">   <v:formulas>    <v:f eqn="if lineDrawn pixelLineWidth 0">    <v:f eqn="sum @0 1 0">    <v:f eqn="sum 0 0 @1">    <v:f eqn="prod @2 1 2">    <v:f eqn="prod @3 21600 pixelWidth">    <v:f eqn="prod @3 21600 pixelHeight">    <v:f eqn="sum @0 0 1">    <v:f eqn="prod @6 1 2">    <v:f eqn="prod @7 21600 pixelWidth">    <v:f eqn="sum @8 21600 0">    <v:f eqn="prod @7 21600 pixelHeight">    <v:f eqn="sum @10 21600 0">   </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas>   <v:path gradientshapeok="t" o:connecttype="rect" o:extrusionok="f">   <o:lock aspectratio="t" v:ext="edit">  </o:lock></v:path></v:stroke></v:shapetype><v:shape alt="*" id="bullet1021526" o:spid="_x0000_i1025" style="height: 5.25pt; width: 5.25pt;" type="#_x0000_t75"><o:p></o:p></v:shape></span></div></td>  <td style="padding: 0in 0in 0in 0in; width: 100.0%;" valign="bottom" width="100%">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">AVG<o:p></o:p></span></div></td> </tr><tr>  <td style="padding: 0in 0in 0in 0in;" valign="bottom">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><v:shape alt="*" id="bullet1021527" o:spid="_x0000_i1026" style="height: 5.25pt; width: 5.25pt;" type="#_x0000_t75"><o:p></o:p></v:shape></span></div></td>  <td style="padding: 0in 0in 0in 0in; width: 100.0%;" valign="bottom" width="100%">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">COUNT<o:p></o:p></span></div></td> </tr></tbody></table><div class="MsoNormal" style="margin-bottom: 5pt; text-align: justify;"><br /></div><table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable"> <tbody><tr>  <td style="padding: 0in 0in 0in 0in;" valign="bottom">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><v:shape alt="*" id="bullet1021528" o:spid="_x0000_i1027" style="height: 5.25pt; width: 5.25pt;" type="#_x0000_t75"><o:p></o:p></v:shape></span></div></td>  <td style="padding: 0in 0in 0in 0in; width: 100.0%;" valign="bottom" width="100%">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">FIRST<o:p></o:p></span></div></td> </tr><tr>  <td style="padding: 0in 0in 0in 0in;" valign="bottom">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><v:shape alt="*" id="bullet1021529" o:spid="_x0000_i1028" style="height: 5.25pt; width: 5.25pt;" type="#_x0000_t75"><o:p></o:p></v:shape></span></div></td>  <td style="padding: 0in 0in 0in 0in; width: 100.0%;" valign="bottom" width="100%">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">LAST<o:p></o:p></span></div></td> </tr></tbody></table><div class="MsoNormal" style="margin-bottom: 5pt; text-align: justify;"><br /></div><table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable"> <tbody><tr>  <td style="padding: 0in 0in 0in 0in;" valign="bottom">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><v:shape alt="*" id="bullet1021530" o:spid="_x0000_i1029" style="height: 5.25pt; width: 5.25pt;" type="#_x0000_t75"><o:p></o:p></v:shape></span></div></td>  <td style="padding: 0in 0in 0in 0in; width: 100.0%;" valign="bottom" width="100%">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">MAX<o:p></o:p></span></div></td> </tr><tr>  <td style="padding: 0in 0in 0in 0in;" valign="bottom">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><v:shape alt="*" id="bullet1021531" o:spid="_x0000_i1030" style="height: 5.25pt; width: 5.25pt;" type="#_x0000_t75"><o:p></o:p></v:shape></span></div></td>  <td style="padding: 0in 0in 0in 0in; width: 100.0%;" valign="bottom" width="100%">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">MEDIAN<o:p></o:p></span></div></td> </tr></tbody></table><div class="MsoNormal" style="margin-bottom: 5pt; text-align: justify;"><br /></div><table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable"> <tbody><tr>  <td style="padding: 0in 0in 0in 0in;" valign="bottom">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><v:shape alt="*" id="bullet1022098" o:spid="_x0000_i1031" style="height: 5.25pt; width: 5.25pt;" type="#_x0000_t75"><o:p></o:p></v:shape></span></div></td>  <td style="padding: 0in 0in 0in 0in; width: 100.0%;" valign="bottom" width="100%">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">MIN<o:p></o:p></span></div></td> </tr><tr>  <td style="padding: 0in 0in 0in 0in;" valign="bottom">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><v:shape alt="*" id="bullet1022100" o:spid="_x0000_i1032" style="height: 5.25pt; width: 5.25pt;" type="#_x0000_t75"><o:p></o:p></v:shape></span></div></td>  <td style="padding: 0in 0in 0in 0in; width: 100.0%;" valign="bottom" width="100%">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">PERCENTILE<o:p></o:p></span></div></td> </tr></tbody></table><div class="MsoNormal" style="margin-bottom: 5pt; text-align: justify;"><br /></div><table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable"> <tbody><tr>  <td style="padding: 0in 0in 0in 0in;" valign="bottom">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><v:shape alt="*" id="bullet1028034" o:spid="_x0000_i1033" style="height: 5.25pt; width: 5.25pt;" type="#_x0000_t75"><o:p></o:p></v:shape></span></div></td>  <td style="padding: 0in 0in 0in 0in; width: 100.0%;" valign="bottom" width="100%">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">STDDEV<o:p></o:p></span></div></td> </tr><tr>  <td style="padding: 0in 0in 0in 0in;" valign="bottom">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><v:shape alt="*" id="bullet1028036" o:spid="_x0000_i1034" style="height: 5.25pt; width: 5.25pt;" type="#_x0000_t75"><o:p></o:p></v:shape></span></div></td>  <td style="padding: 0in 0in 0in 0in; width: 100.0%;" valign="bottom" width="100%">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">SUM<o:p></o:p></span></div></td> </tr></tbody></table><div class="MsoNormal" style="margin-bottom: 5pt; text-align: justify;"><br /></div><table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable"> <tbody><tr>  <td style="padding: 0in 0in 0in 0in;" valign="bottom">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><v:shape alt="*" id="bullet1028047" o:spid="_x0000_i1035" style="height: 5.25pt; width: 5.25pt;" type="#_x0000_t75"><o:p></o:p></v:shape></span></div></td>  <td style="padding: 0in 0in 0in 0in; width: 100.0%;" valign="bottom" width="100%">  <div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">VARIANCE<o:p></o:p></span></div></td> </tr></tbody></table><div class="MsoNormal" style="text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">When you use any of these functions, you must use them in an expression within an Aggregator transformation. <o:p></o:p></span></div><h2 style="text-align: justify; text-justify: inter-ideograph;"><span style="font-family: "Calibri","sans-serif"; font-size: 12.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;"><span style="color: red;">Tips</span><o:p></o:p></span></h2><div class="troubleshoot" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">Use sorted input to decrease the use of aggregate caches.<o:p></o:p></span></div><div class="body" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">Sorted input reduces the amount of data cached during the session and improves session performance. Use this option with the Sorter transformation to pass sorted data to the Aggregator transformation.<o:p></o:p></span></div><div class="troubleshoot" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">Limit connected input/output or output ports.<o:p></o:p></span></div><div class="body" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">Limit the number of connected input/output or output ports to reduce the amount of data the Aggregator transformation stores in the data cache.<o:p></o:p></span></div><div class="troubleshoot" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">Filter the data before aggregating it.<o:p></o:p></span></div><div class="body" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">If you use a Filter transformation in the mapping, place the transformation before the Aggregator transformation to reduce unnecessary aggregation. <o:p></o:p></span></div><div class="body" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;"><br /></span></div><div class="body" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;"><span style="color: red;">Normalizer Transformation:</span><o:p></o:p></span></b></div><div class="body" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;"><span style="color: red;"><br /></span></span></b></div><div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Transformation type:<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Active<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 5pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Connected<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 5pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">The Normalizer transformation receives a row that contains multiple-occurring columns and returns a row for each instance of the multiple-occurring data.<o:p></o:p></span></div><div class="body" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">The Normalizer transformation parses multiple-occurring columns from COBOL sources, relational tables, or other sources. It can process multiple record types from a COBOL source that contains a REDEFINES clause.<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 5pt; text-align: justify;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman";">The Normalizer transformation generates a key for each source row. The Integration Service increments the generated key sequence number each time it processes a source row. When the source row contains a multiple-occurring column or a multiple-occurring group of columns, the Normalizer transformation returns a row for each occurrence. Each row contains the same generated key value.</span><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div><div class="body" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;"><span style="color: red;">SQL Transformation</span><o:p></o:p></span></b></div><div class="body" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;"><span style="color: red;"><br /></span></span></b></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><b><span style="font-size: 12pt;">Transformation type:</span></b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Active/Passive<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 5pt;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Connected<o:p></o:p></span></div><div class="body"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">The SQL transformation processes SQL queries midstream in a pipeline. You can insert, delete, update, and retrieve rows from a database. You can pass the database connection information to the SQL transformation as input data at run time. The transformation processes external SQL scripts or SQL queries that you create in an SQL editor. The SQL transformation processes the query and returns rows and database errors. <o:p></o:p></span></div><div class="MsoNormal"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">For example, you might need to create database tables before adding new transactions. You can create an SQL transformation to create the tables in a workflow. The SQL transformation returns database errors in an output port. You can configure another workflow to run if the SQL transformation returns no errors.<o:p></o:p></span></div><div class="MsoNormal"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">When you create an SQL transformation, you configure the following options:<o:p></o:p></span></div><table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable"> <tbody><tr>  <td colspan="2" style="padding: 0in 0in 0in 0in;" valign="bottom"></td>  <td colspan="2" style="padding: 0in 0in 0in 0in; width: 100.0%;" valign="bottom" width="100%"></td> </tr><tr>  <td style="padding: 0in 0in 0in 0in;" valign="bottom"></td>  <td colspan="2" style="padding: 0in 0in 0in 0in; width: 100.0%;" valign="bottom" width="100%"></td>  <td style="border: none; mso-cell-special: placeholder; padding: 0in 0in 0in 0in;" width="48"><div class="MsoNormal"><br /></div></td> </tr><tr height="0">  <td style="border: none;" width="0"></td>  <td style="border: none;" width="374"></td>  <td style="border: none;" width="374"></td>  <td style="border: none;" width="0"></td> </tr></tbody></table><div class="MsoNormal" style="margin-bottom: 5pt;"><br /></div><table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable"> <tbody><tr>  <td style="padding: 0in 0in 0in 0in;" valign="bottom"></td>  <td style="padding: 0in 0in 0in 0in; width: 100.0%;" valign="bottom" width="100%"></td> </tr><tr>  <td style="padding: 0in 0in 0in 0in;" valign="bottom"></td>  <td style="padding: 0in 0in 0in 0in; width: 100.0%;" valign="bottom" width="100%"></td> </tr></tbody></table><div class="MsoNormal" style="margin-bottom: 5pt;"><br /></div><table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="mso-cellspacing: 0in; mso-padding-alt: 0in 0in 0in 0in; mso-yfti-tbllook: 1184; width: 100%px;"> <tbody><tr>  <td style="padding: 0in 0in 0in 0in;" valign="bottom"></td>  <td style="padding: 0in 0in 0in 0in; width: 99.94%;" valign="bottom" width="99%"></td> </tr></tbody></table><div class="MsoNormal" style="margin-bottom: 5pt;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Mode.</span></b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"> The SQL transformation runs in one of the following modes:<o:p></o:p></span></div><table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="mso-cellspacing: 0in; mso-padding-alt: 0in 0in 0in 0in; mso-yfti-tbllook: 1184; width: 100%px;"> <tbody><tr>  <td style="padding: 0in 0in 0in 0in;" valign="bottom"></td>  <td style="padding: 0in 0in 0in 0in; width: 99.94%;" valign="bottom" width="99%">  <div class="MsoNormal" style="margin-bottom: 0.0001pt;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Script mode.</span></b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"> The SQL transformation runs ANSI SQL scripts that are   externally located. You pass a script name to the transformation with each   input row. The SQL transformation outputs one row for each input row.<o:p></o:p></span></div></td> </tr></tbody></table><div class="MsoNormal" style="margin-bottom: 5pt;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Query mode. </span></b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">The SQL transformation executes a query that you define in a query editor. You can pass strings or parameters to the query to define dynamic queries or change the selection parameters. You can output multiple rows when the query has a SELECT statement. <o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 5pt;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Database type. </span></b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">The type of database the SQL transformation connects to. <o:p></o:p></span></div><div class="body" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">Connection type. </span></b><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">Pass database connection information to the SQL transformation or use a connection object.<o:p></o:p></span></div><div class="body" style="text-align: justify; text-justify: inter-ideograph;"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">Script Mode<o:p></o:p></span></div><div class="body"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">An SQL transformation running in script mode runs SQL scripts from text files. You pass each script file name from the source to the SQL transformation ScriptName port. The script file name contains the complete path to the script file.<o:p></o:p></span></div><div class="body"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">When you configure the transformation to run in script mode, you create a passive transformation. The transformation returns one row for each input row. The output row contains results of the query and any database error.<o:p></o:p></span></div><div class="body"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">When the SQL transformation runs in script mode, the query statement and query data do not change. When you need to run different queries in script mode, you pass the scripts in the source data. Use script mode to run data definition queries such as creating or dropping tables. <o:p></o:p></span></div><div class="body"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">When you configure an SQL transformation to run in script mode, the Designer adds the ScriptName input port to the transformation<o:p></o:p></span></div><div class="MsoNormal"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">An SQL transformation configured for script mode has the following default ports:<o:p></o:p></span></div><table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable"> <tbody><tr>  <td style="background: #CCCCFF; border-bottom: none; border: solid black 1.0pt; mso-border-left-alt: solid black .5pt; mso-border-right-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 4.0pt 6.0pt 2.0pt .6pt;" valign="top">  <div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Port        <o:p></o:p></span></div></td>  <td style="background: #CCCCFF; border-bottom: none; border: solid black 1.0pt; mso-border-left-alt: solid black .5pt; mso-border-right-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 4.0pt 6.0pt 2.0pt .6pt;" valign="top">  <div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Type  <o:p></o:p></span></div></td>  <td style="background: #CCCCFF; border-bottom: none; border: solid black 1.0pt; mso-border-left-alt: solid black .5pt; mso-border-right-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 4.0pt 6.0pt 2.0pt .6pt;" valign="top">  <div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Description                                                               <o:p></o:p></span></div></td> </tr><tr>  <td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; padding: 0in 0in 0in 0in;" valign="top">  <div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">ScriptName<o:p></o:p></span></div></td>  <td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; padding: 0in 0in 0in 0in;" valign="top">  <div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Input<o:p></o:p></span></div></td>  <td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; padding: 0in 0in 0in 0in;" valign="top">  <div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Receives the name of the script to   execute for the current row. <o:p></o:p></span></div></td> </tr><tr>  <td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; padding: 0in 0in 0in 0in;" valign="top">  <div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">ScriptResult<o:p></o:p></span></div></td>  <td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; padding: 0in 0in 0in 0in;" valign="top">  <div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Output<o:p></o:p></span></div></td>  <td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; padding: 0in 0in 0in 0in;" valign="top">  <div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Returns PASSED if the script   execution succeeds for the row. Otherwise contains FAILED.<o:p></o:p></span></div></td> </tr><tr>  <td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; padding: 0in 0in 0in 0in;" valign="top">  <div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">ScriptError<o:p></o:p></span></div></td>  <td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; padding: 0in 0in 0in 0in;" valign="top">  <div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Output<o:p></o:p></span></div></td>  <td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; padding: 0in 0in 0in 0in;" valign="top">  <div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Returns errors that occur when a   script fails for a row. <o:p></o:p></span></div></td> </tr></tbody></table><div class="MsoNormal"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoNormal"><b><span style="color: blue;">Data Ware Housing Concepts</span></b></div><div class="MsoNormal"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoNormal"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><span style="color: red;">Q : Script Mode Rules and Guidelines?</span><o:p></o:p></span></b></div><div class="MsoNormal"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoNormal"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><span style="color: blue;">Ans :</span></span></b></div><div class="MsoNormal"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><br /></span></b></div><div class="MsoListParagraphCxSpFirst" style="margin-bottom: 0.0001pt; text-indent: -0.25in;"><span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">         </span></span><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Use the following rules and guidelines for an SQL transformation that runs in script mode:<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -0.25in;"><span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">         </span></span><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">You can use a static or dynamic database connection with script mode.<o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="margin-bottom: 0.0001pt; text-indent: -0.25in;"><span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">         </span></span><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">To include multiple query statements in a script, you can separate them with a semicolon.<o:p></o:p></span></div><div class="body" style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l6 level1 lfo11; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">         </span></span><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">You can use mapping variables or parameters in the script file name<o:p></o:p></span></div><div class="MsoListParagraphCxSpFirst" style="margin-bottom: 0.0001pt; text-indent: -0.25in;"><span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">         </span></span><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">The script code page defaults to the locale of the operating system. You can change the locale of the script.<o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="margin-bottom: 0.0001pt; text-indent: -0.25in;"><span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">         </span></span><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">You cannot use scripting languages such as Oracle PL/SQL or Microsoft/Sybase T-SQL in the script.<o:p></o:p></span></div><div class="body" style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l6 level1 lfo11; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;"><span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">         </span></span><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">You cannot use nested scripts where the SQL script calls another SQL script<o:p></o:p></span></div><div class="MsoListParagraphCxSpFirst" style="margin-bottom: 0.0001pt; text-indent: -0.25in;"><span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">         </span></span><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">A script cannot accept run-time arguments.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -0.25in;"><span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">         </span></span><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">The script file must be accessible by the Integration Service. The Integration Service must have read permissions on the directory that contains the script. If the Integration Service uses operating system profiles, the operating system user of the operating system profile must have read permissions on the directory that contains the script.<o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="margin-bottom: 0.0001pt; text-indent: -0.25in;"><span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">         </span></span><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">The Integration Service ignores the output of any SELECT statement you include in the SQL script. The SQL transformation in script mode does not output more than one row of data for each input row.<o:p></o:p></span></div><div class="body" style="margin-bottom: .0001pt; margin: 0in; text-align: justify; text-justify: inter-ideograph;"><br /></div><div class="body" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;"><span style="color: red;">Q : Query Mode</span></span></b></div><div class="body" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;"><br /></span></b></div><div class="body"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">When an SQL transformation runs in query mode, it executes an SQL query that you define in the transformation. You pass strings or parameters to the query from the transformation input ports to change the query statement or the query data. <o:p></o:p></span></div><div class="body"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">When you configure the SQL transformation to run in query mode, you create an active transformation. The transformation can return multiple rows for each input row.<o:p></o:p></span></div><div class="body"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">Create queries in the SQL transformation SQL Editor. To create a query, type the query statement in the SQL Editor main window. The SQL Editor provides a list of the transformation ports that you can reference in the query. <o:p></o:p></span></div><div class="body"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">You can create the following types of SQL queries in the SQL transformation:<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 5pt;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Static SQL query</span></b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">. The query statement does not change, but you can use query parameters to change the data. The Integration Service prepares the query once and runs the query for all input rows.<o:p></o:p></span></div><table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable"> <tbody><tr>  <td style="padding: 0in 0in 0in 0in; width: 100.0%;" valign="bottom" width="100%">  <div class="MsoNormal" style="margin-bottom: 0.0001pt;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Dynamic SQL query</span></b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">. You can change the query statements and the data. The   Integration Service prepares a query for each input row.<o:p></o:p></span></div></td> </tr></tbody></table><div class="MsoNormal"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">When you create a static query, the Integration Service prepares the SQL procedure once and executes it for each row. When you create a dynamic query, the Integration Service prepares the SQL for each input row. You can optimize performance by creating static queries. <o:p></o:p></span></div><div class="MsoNormal"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><br /></span></div><div class="body" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;"><span style="color: red;">Query Mode Rules and Guidelines</span><o:p></o:p></span></b></div><div class="body" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;"><span style="color: red;"><br /></span></span></b></div><div class="body" style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l9 level1 lfo12; text-indent: -.25in;"><span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">         </span></span><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">Use the following rules and guidelines when you configure the SQL transformation to run in query mode:<o:p></o:p></span></div><div class="MsoListParagraphCxSpFirst" style="margin-bottom: 0.0001pt; text-indent: -0.25in;"><span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">         </span></span><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">The number and the order of the output ports must match the number and order of the fields in the query SELECT clause.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -0.25in;"><span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">         </span></span><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">The native datatype of an output port in the transformation must match the datatype of the corresponding column in the database. The Integration Service generates a row error when the datatypes do not match.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -0.25in;"><span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">         </span></span><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">When the SQL query contains an INSERT, UPDATE, or DELETE clause, the transformation returns data to the SQLError port, the pass-through ports, and the NumRowsAffected port when it is enabled. If you add output ports the ports receive NULL data values.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -0.25in;"><span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">         </span></span><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">When the SQL query contains a SELECT statement and the transformation has a pass-through port, the transformation returns data to the pass-through port whether or not the query returns database data. The SQL transformation returns a row with NULL data in the output ports.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -0.25in;"><span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">         </span></span><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">You cannot add the "_output" suffix to output port names that you create.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -0.25in;"><span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">         </span></span><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">You cannot use the pass-through port to return data from a SELECT query. <o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -0.25in;"><span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">         </span></span><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">When the number of output ports is more than the number of columns in the SELECT clause, the extra ports receive a NULL value.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -0.25in;"><span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">         </span></span><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">When the number of output ports is less than the number of columns in the SELECT clause, the Integration Service generates a row error. <o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" style="margin-bottom: 0.0001pt; text-indent: -0.25in;"><span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">         </span></span><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">You can use string substitution instead of parameter binding in a query. However, the input ports must be string datatypes. <o:p></o:p></span></div><div class="body" style="margin-bottom: .0001pt; margin: 0in; text-align: justify; text-justify: inter-ideograph;"><br /></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;">Java Transformation<span class="topicalias"> </span>Overview</span><o:p></o:p></span></b></div><div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";"><span style="color: red;"><br /></span></span></b></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><b><span style="font-size: 12pt;">Transformation type:</span></b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Active/Passive<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 5pt;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Connected<o:p></o:p></span></div><div class="body"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">The Java transformation provides a simple native programming interface to define transformation functionality with the Java programming language. You can use the Java transformation to quickly define simple or moderately complex transformation functionality without advanced knowledge of the Java programming language or an external Java development environment. <o:p></o:p></span></div><div class="body"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">For example, you can define transformation logic to loop through input rows and generate multiple output rows based on a specific condition. You can also use expressions, user-defined functions, unconnected transformations, and mapping variables in the Java code.<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Transaction Control Transformation<o:p></o:p></span></b></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><b><span style="font-size: 12pt;">Transformation type:</span></b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Active<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Connected<o:p></o:p></span></div><div class="body" style="margin-bottom: .0001pt; margin-bottom: 0in;"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">PowerCenter lets you control commit and roll back transactions based on a set of rows that pass through a Transaction Control transformation. A transaction is the set of rows bound by commit or roll back rows. You can define a transaction based on a varying number of input rows. You might want to define transactions based on a group of rows ordered on a common key, such as employee ID or order entry date.<o:p></o:p></span></div><div class="body" style="margin-bottom: .0001pt; margin-bottom: 0in;"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">In PowerCenter, you define transaction control at the following levels:<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; text-justify: inter-ideograph;"><b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Within a mapping.</span></b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman";">Within a mapping, you use the Transaction Control transformation to define a transaction. You define transactions using an expression in a Transaction Control transformation. Based on the return value of the expression, you can choose to commit, roll back, or continue without any transaction changes.<o:p></o:p></span></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Within a session. </span></b><span style="font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">When you configure a session, you configure it for user-defined commit. You can choose to commit or roll back a transaction if the Integration Service fails to transform or write any row to the target.<o:p></o:p></span></div><div class="body" style="margin-bottom: .0001pt; margin-bottom: 0in;"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">When you run the session, the Integration Service evaluates the expression for each row that enters the transformation. When it evaluates a commit row, it commits all rows in the transaction to the target or targets. When the Integration Service evaluates a roll back row, it rolls back all rows in the transaction from the target or targets. <o:p></o:p></span></div><div class="body" style="margin-bottom: .0001pt; margin-bottom: 0in;"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;">If the mapping has a flat file target you can generate an output file each time the Integration Service starts a new transaction. You can dynamically name each target flat file.<b><o:p></o:p></b></span></div><div class="body" style="margin-bottom: .0001pt; margin-bottom: 0in;"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;"><br /></span></div><h3 class="post-title entry-title" style="background-color: white; font-family: Oswald, sans-serif; font-weight: normal; line-height: 24px; margin: 0px 0px 10px; padding: 0px;"><a href="http://foryooth.blogspot.in/2014/02/data-warehousing-concepts-interview.html" style="display: block; outline: none; text-decoration: none;"><span style="color: red; font-size: small;">Data Warehousing Concepts & IBM Info Sphere Data stage Interview Questions with Answers</span></a></h3><div class="post-header-line-1" style="background-color: white; color: #555555; font-family: Arial, Helvetica, sans-serif; font-size: 13px;"></div><br /><div class="body" style="margin-bottom: .0001pt; margin-bottom: 0in;"><a href="http://foryooth.blogspot.in/2014/02/data-warehousing-concepts-data.html" style="color: #333333; display: inline !important; font-family: Oswald, sans-serif; line-height: 24px; outline: none; text-decoration: none;"><span style="color: blue;"><span style="font-size: small;">Data Warehousing Concepts | Data Warehousing Interview Questions with Answers</span></span></a></div><div style="background-color: white; color: #555555; font-family: Arial, Helvetica, sans-serif; line-height: 20px;"><h3 style="font-weight: normal; line-height: 1; margin-bottom: 16px;"><span style="line-height: 30px;"><b><a href="http://foryooth.blogspot.in/2014/02/ibm-info-sphere-data-stage-interview.html" style="color: #de2801; outline: none;" target="_blank"><span style="color: #0c343d;"><span style="font-size: small;">Click here to Oracle & Data Warehousing Interview Questions</span></span></a></b></span></h3></div><div style="background-color: white; color: #555555; font-family: Arial, Helvetica, sans-serif; line-height: 20px;"><span style="line-height: 18px;"><b><a href="http://foryooth.blogspot.in/2014/01/data-integration-in-data-ware-housing.html" style="color: #de2801; outline: none;" target="_blank"><span style="color: #660000;">Click Here to Data Warehousing Concepts</span></a></b></span></div><div style="background-color: white; color: #555555; font-family: Arial, Helvetica, sans-serif; line-height: 20px;"><span style="line-height: 18px;"><br /></span></div><div style="background-color: white; color: #555555; font-family: Arial, Helvetica, sans-serif; line-height: 20px;"><h3 class="post-title entry-title" style="color: #333333; font-family: Oswald, sans-serif; font-weight: normal; line-height: 24px; margin: 0px 0px 10px; padding: 0px;"><a href="http://foryooth.blogspot.in/2013/12/data-stage-full-notes-data-ware-housing.html" style="color: #333333; display: block; outline: none; text-decoration: none;"><span style="color: red;"><span style="font-size: small;">Data Stage Full Notes|| Data Ware Housing Concepts|| Data Stage Scenarios</span></span></a></h3></div><div class="body" style="margin-bottom: .0001pt; margin-bottom: 0in;"><span style="font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-hansi-theme-font: minor-latin;"><br /></span></div><script src="http://www.yupptv.com/js/etv2embed.js" type="text/javascript"></script></div>

Data Warehousing Interview Questions || Informatica & IBM Info Sphere Data Stage Interview Questions

Data Warehousing Interview Questions Here we are providing Data Ware Housing Interview Questions in this Page. This questions are very usefu...