Are you over 18 and want to see adult content?
More Annotations
![A complete backup of manilatonight.com](https://www.archivebay.com/archive/16c46c56-1830-4343-af08-bcf5107d3281.png)
A complete backup of manilatonight.com
Are you over 18 and want to see adult content?
![A complete backup of doina-touchinghearts.blogspot.com](https://www.archivebay.com/archive/3dd4fa84-12d4-4816-84f9-4301fdd6364c.png)
A complete backup of doina-touchinghearts.blogspot.com
Are you over 18 and want to see adult content?
![A complete backup of unchienenville.com](https://www.archivebay.com/archive/1df54e34-27f4-4dc9-b22f-a90dafb7ce6b.png)
A complete backup of unchienenville.com
Are you over 18 and want to see adult content?
![A complete backup of gwen-howard-644b.squarespace.com](https://www.archivebay.com/archive/6011a610-98d8-478f-b8de-f76f75b13feb.png)
A complete backup of gwen-howard-644b.squarespace.com
Are you over 18 and want to see adult content?
![A complete backup of simplelivingcreativelearning.com](https://www.archivebay.com/archive/07fd575b-c6d9-4440-b07a-e03a41654838.png)
A complete backup of simplelivingcreativelearning.com
Are you over 18 and want to see adult content?
Favourite Annotations
![A complete backup of scrabblecheatboard.com](https://www.archivebay.com/archive/d36db2b6-fc89-4f78-a96d-f6a0655f067c.png)
A complete backup of scrabblecheatboard.com
Are you over 18 and want to see adult content?
![A complete backup of adventureboogies.com](https://www.archivebay.com/archive/904b7f71-827f-43fd-ba6b-08b621c65a39.png)
A complete backup of adventureboogies.com
Are you over 18 and want to see adult content?
![A complete backup of volatilityfactor2.com](https://www.archivebay.com/archive/4b7b9966-7c06-4280-9d85-6d5f3bdc9016.png)
A complete backup of volatilityfactor2.com
Are you over 18 and want to see adult content?
![A complete backup of cms7thgrade.weebly.com](https://www.archivebay.com/archive/df297cba-72b9-482b-ae9d-323223adf88e.png)
A complete backup of cms7thgrade.weebly.com
Are you over 18 and want to see adult content?
![A complete backup of timberhomeliving.com](https://www.archivebay.com/archive/e76eb77b-745f-4e36-992a-f8ae30034827.png)
A complete backup of timberhomeliving.com
Are you over 18 and want to see adult content?
![A complete backup of boschplus-co.com](https://www.archivebay.com/archive/953d3e3e-87c6-4d2b-89e5-778eec8cbe02.png)
A complete backup of boschplus-co.com
Are you over 18 and want to see adult content?
Text
Reso
OCI EXAM QUESTION & ANSWERS 1. Which Oracle Cloud Infrastructure (OCI) service can send you an alert when you might exceed your spending threshold? A. Budgets B.Monito
AUDIT COLUMNS IN DATAWAREHOUSE Audit Columns in Datawarehouse. In data warehouse and data marts we maintain timestamp columns like “Last_Modified_Date or Created_Date” to track the exact date and time when the records were updated or inserted.These columns are called Audit Columns. But audit columns won’t track the deletion of columns. INFORMATICA SCENARIO: HOW TO LOAD DATA IN CYCLIC ORDER In this scenario we will load the records present in the DEP table to Flat files in a cyclic order such that the first record will go to TargetFile01 ,2 nd to TargetFile 02 ,3 rd to Target File03 and 4 th record again to TargetFile01. HOW TO CONFIGURE EMAIL TASK IN INFORMATICA WITH EXAMPLES Email task is used to send emails while running the workflow.Using email task we can get failure and success notifications. To explain this lets take the example of a workflow with two sessions.Session1 and Session2. a)Go to create task and create an Email Task and name it as Test_email. b)Also Enter the following details. SCD TYPE 2,SLOWLY CHANGING DIMENSION USE,EXAMPLE,ADVANTAGE In Type 2 Slowly Changing Dimension, a new record is added to the table to represent the new information. Therefore, both the original and the new record will be present. INFORMATICA POWERCENTER SESSION PARTITIONING-TYPE OF Informatica provides you the option of enhancing the performance of the Informatica session by the The PowerCenter® Partitioning Option. After tuning all the performance bottlenecks we can further improve the performance by addition partitions. We can either go for Dynamic partitioning (number of partition passed as parameter) or Non-dynamic SOURCE QUALIFIER VERSUS JOINER TRANSFORMATION When a mapping uses related relational sources, you can join both sources in one Source Qualifier transformation. During the session, the source database performs the join before passing data to the Integration Service. HOW TO UNLOCK THE LOCKED TABLE IN ORACLE What you presented is a theoretical scenario for a system with very few users and little activity. In real life there are systems with multiple DMLs going on in parallel so while you kill off the sessions currently holding locks on your object, you will get new sessions getting locks before you are through with your loop. DATAWAREHOUSE CONCEPTS Power BI is popular for its versatility, interactivity, aesthetic designs, extensive connectivity to databases and ease of creating low-effort dashboards and also provides multiple software connectors and services. Power BI can generate custom dashboards depending on what data is relevant, and what information you need access to. OCI EXAM QUESTION & ANSWERS 1. Which capability enables you to search, purchase, and start using software in your Oracle Cloud Infrastructure (OCI) tenancy? A. OCIReso
OCI EXAM QUESTION & ANSWERS 1. Which Oracle Cloud Infrastructure (OCI) service can send you an alert when you might exceed your spending threshold? A. Budgets B.Monito
AUDIT COLUMNS IN DATAWAREHOUSE Audit Columns in Datawarehouse. In data warehouse and data marts we maintain timestamp columns like “Last_Modified_Date or Created_Date” to track the exact date and time when the records were updated or inserted.These columns are called Audit Columns. But audit columns won’t track the deletion of columns. HOW TO CONFIGURE EMAIL TASK IN INFORMATICA WITH EXAMPLES Email task is used to send emails while running the workflow.Using email task we can get failure and success notifications. To explain this lets take the example of a workflow with two sessions.Session1 and Session2. a)Go to create task and create an Email Task and name it as Test_email. b)Also Enter the following details. INFORMATICA SCENARIO: HOW TO LOAD DATA IN CYCLIC ORDER In this scenario we will load the records present in the DEP table to Flat files in a cyclic order such that the first record will go to TargetFile01 ,2 nd to TargetFile 02 ,3 rd to Target File03 and 4 th record again to TargetFile01. SCD TYPE 2,SLOWLY CHANGING DIMENSION USE,EXAMPLE,ADVANTAGE In Type 2 Slowly Changing Dimension, a new record is added to the table to represent the new information. Therefore, both the original and the new record will be present. INFORMATICA POWERCENTER SESSION PARTITIONING-TYPE OF We can either go for Dynamic partitioning (number of partition passed as parameter) or Non-dynamic partition (number of partition are fixed while coding). Apart from used for optimizing the session, Informatica partition become useful in situations where we need to load huge volume of data or when we are using Informatica source which already has partitions defined, and using those partitions SOURCE QUALIFIER VERSUS JOINER TRANSFORMATION When a mapping uses related relational sources, you can join both sources in one Source Qualifier transformation. During the session, the source database performs the join before passing data to the Integration Service. HOW TO UNLOCK THE LOCKED TABLE IN ORACLE What you presented is a theoretical scenario for a system with very few users and little activity. In real life there are systems with multiple DMLs going on in parallel so while you kill off the sessions currently holding locks on your object, you will get new sessions getting locks before you are through with your loop. OCI EXAM QUESTION & ANSWERS 1. Which capability enables you to search, purchase, and start using software in your Oracle Cloud Infrastructure (OCI) tenancy? A. OCIReso
WHAT IS A FACTLESS FACT TABLE?WHERE WE USE Factless fact tables for Events The first type of factless fact table is a table that records an event. Many event-tracking tables in dimensional data warehouses turn out to be factless.Sometimes there seem to be no facts associated with an important business process.Events or activities occur that you wish to track, but you find no measurements. AUDIT COLUMNS IN DATAWAREHOUSE Audit Columns in Datawarehouse. In data warehouse and data marts we maintain timestamp columns like “Last_Modified_Date or Created_Date” to track the exact date and time when the records were updated or inserted.These columns are called Audit Columns. But audit columns won’t track the deletion of columns. IBM COGNOS FRAMEWORK MANAGER IBM Cognos Framework Manager is the IBM Cognos BI modeling tool for creating and managing business related metadata for use in IBM Cognos BI analysis and reporting.IBM Cognos Framework Manager is the metadatamodel development
HOW TO RUN INFORMATICA WORKFLOW USING UNIX COMMAND How to run Informatica Workflow using Unix command. To run the workflow first need to got the command line and go to the folder where the executable is installed. Mostly you can find the pmcmd command in \server\bin\directory. LIST OF DWBI TOOLS USED IN DATA WAREHOUSING While I do think Informatica should consider the English spelling for "PowerCentre" unfortunately the only spelling used today is the American one "PowerCenter". REQUIREMENTS GATHERING PHASE(HLD & LLD) IN DATA WAREHOUSE Requirements Gathering Phase (HLD & LLD) in Data Warehouse Project Life Cycle. Business Analyst (BA): He is the person or a mediator between the client and the organization. First Business Analyst is going to interact with the client to know about the client business and pain-areas, from that business analysis BA will prepare thedocument
HOW TO UNLOCK THE LOCKED TABLE IN ORACLE What you presented is a theoretical scenario for a system with very few users and little activity. In real life there are systems with multiple DMLs going on in parallel so while you kill off the sessions currently holding locks on your object, you will get new sessions getting locks before you are through with your loop. JOINS IN ORACLE-DIFFERENT JOINS IN ORACLE WITH EXAMPLES 3. If a join involves in more than two tables then Oracle joins first two tables based on the joins condition and then compares the result with the next table and so on. PIG VS HIVE: MAIN DIFFERENCES BETWEEN APACHE PIG AND HIVE Pig was created by researchers at Yahoo, and has the flexibility of multiple query approach. Although somewhat similar to SQL the traditional language for data analysis in some ways, doesn’t have its declarative nature and has limitations like- being dependent on relational database schemas. DATAWAREHOUSE CONCEPTS Power BI is popular for its versatility, interactivity, aesthetic designs, extensive connectivity to databases and ease of creating low-effort dashboards and also provides multiple software connectors and services. Power BI can generate custom dashboards depending on what data is relevant, and what information you need access to. OCI EXAM QUESTION & ANSWERS 1. Which Oracle Cloud Infrastructure (OCI) service can send you an alert when you might exceed your spending threshold? A. Budgets B.Monito
INFORMATICA SCENARIO: HOW TO LOAD DATA IN CYCLIC ORDER In this scenario we will load the records present in the DEP table to Flat files in a cyclic order such that the first record will go to TargetFile01 ,2 nd to TargetFile 02 ,3 rd to Target File03 and 4 th record again to TargetFile01. AUDIT COLUMNS IN DATAWAREHOUSE Audit Columns in Datawarehouse. In data warehouse and data marts we maintain timestamp columns like “Last_Modified_Date or Created_Date” to track the exact date and time when the records were updated or inserted.These columns are called Audit Columns. But audit columns won’t track the deletion of columns. HOW TO CONFIGURE EMAIL TASK IN INFORMATICA WITH EXAMPLES Email task is used to send emails while running the workflow.Using email task we can get failure and success notifications. To explain this lets take the example of a workflow with two sessions.Session1 and Session2. a)Go to create task and create an Email Task and name it as Test_email. b)Also Enter the following details. INFORMATICA POWERCENTER SESSION PARTITIONING-TYPE OF Informatica provides you the option of enhancing the performance of the Informatica session by the The PowerCenter® Partitioning Option. After tuning all the performance bottlenecks we can further improve the performance by addition partitions. We can either go for Dynamic partitioning (number of partition passed as parameter) or Non-dynamic SCD TYPE 2,SLOWLY CHANGING DIMENSION USE,EXAMPLE,ADVANTAGE In Type 2 Slowly Changing Dimension, a new record is added to the table to represent the new information. Therefore, both the original and the new record will be present. IBM COGNOS FRAMEWORK MANAGER IBM Cognos Framework Manager is the IBM Cognos BI modeling tool for creating and managing business related metadata for use in IBM Cognos BI analysis and reporting.IBM Cognos Framework Manager is the metadatamodel development
SOURCE QUALIFIER VERSUS JOINER TRANSFORMATION When a mapping uses related relational sources, you can join both sources in one Source Qualifier transformation. During the session, the source database performs the join before passing data to the Integration Service. HOW TO RUN INFORMATICA WORKFLOW USING UNIX COMMAND How to run Informatica Workflow using Unix command. To run the workflow first need to got the command line and go to the folder where the executable is installed. Mostly you can find the pmcmd command in \server\bin\directory. DATAWAREHOUSE CONCEPTS Power BI is popular for its versatility, interactivity, aesthetic designs, extensive connectivity to databases and ease of creating low-effort dashboards and also provides multiple software connectors and services. Power BI can generate custom dashboards depending on what data is relevant, and what information you need access to. OCI EXAM QUESTION & ANSWERS 1. Which Oracle Cloud Infrastructure (OCI) service can send you an alert when you might exceed your spending threshold? A. Budgets B.Monito
INFORMATICA SCENARIO: HOW TO LOAD DATA IN CYCLIC ORDER In this scenario we will load the records present in the DEP table to Flat files in a cyclic order such that the first record will go to TargetFile01 ,2 nd to TargetFile 02 ,3 rd to Target File03 and 4 th record again to TargetFile01. AUDIT COLUMNS IN DATAWAREHOUSE Audit Columns in Datawarehouse. In data warehouse and data marts we maintain timestamp columns like “Last_Modified_Date or Created_Date” to track the exact date and time when the records were updated or inserted.These columns are called Audit Columns. But audit columns won’t track the deletion of columns. HOW TO CONFIGURE EMAIL TASK IN INFORMATICA WITH EXAMPLES Email task is used to send emails while running the workflow.Using email task we can get failure and success notifications. To explain this lets take the example of a workflow with two sessions.Session1 and Session2. a)Go to create task and create an Email Task and name it as Test_email. b)Also Enter the following details. INFORMATICA POWERCENTER SESSION PARTITIONING-TYPE OF Informatica provides you the option of enhancing the performance of the Informatica session by the The PowerCenter® Partitioning Option. After tuning all the performance bottlenecks we can further improve the performance by addition partitions. We can either go for Dynamic partitioning (number of partition passed as parameter) or Non-dynamic SCD TYPE 2,SLOWLY CHANGING DIMENSION USE,EXAMPLE,ADVANTAGE In Type 2 Slowly Changing Dimension, a new record is added to the table to represent the new information. Therefore, both the original and the new record will be present. IBM COGNOS FRAMEWORK MANAGER IBM Cognos Framework Manager is the IBM Cognos BI modeling tool for creating and managing business related metadata for use in IBM Cognos BI analysis and reporting.IBM Cognos Framework Manager is the metadatamodel development
SOURCE QUALIFIER VERSUS JOINER TRANSFORMATION When a mapping uses related relational sources, you can join both sources in one Source Qualifier transformation. During the session, the source database performs the join before passing data to the Integration Service. HOW TO RUN INFORMATICA WORKFLOW USING UNIX COMMAND How to run Informatica Workflow using Unix command. To run the workflow first need to got the command line and go to the folder where the executable is installed. Mostly you can find the pmcmd command in \server\bin\directory. AUDIT COLUMNS IN DATAWAREHOUSE Audit Columns in Datawarehouse. In data warehouse and data marts we maintain timestamp columns like “Last_Modified_Date or Created_Date” to track the exact date and time when the records were updated or inserted.These columns are called Audit Columns. But audit columns won’t track the deletion of columns. REQUIREMENTS GATHERING PHASE(HLD & LLD) IN DATA WAREHOUSE Requirements Gathering Phase (HLD & LLD) in Data Warehouse Project Life Cycle. Business Analyst (BA): He is the person or a mediator between the client and the organization. First Business Analyst is going to interact with the client to know about the client business and pain-areas, from that business analysis BA will prepare thedocument
WHAT IS A FACTLESS FACT TABLE?WHERE WE USE Factless fact tables for Events The first type of factless fact table is a table that records an event. Many event-tracking tables in dimensional data warehouses turn out to be factless.Sometimes there seem to be no facts associated with an important business process.Events or activities occur that you wish to track, but you find no measurements. SCD TYPE 1,SLOWLY CHANGING DIMENSION USE,EXAMPLE,ADVANTAGE In Type 1 Slowly Changing Dimension, the new information simply overwrites the original information. In other words, no history iskept.
LIST OF DWBI TOOLS USED IN DATA WAREHOUSING While I do think Informatica should consider the English spelling for "PowerCentre" unfortunately the only spelling used today is the American one "PowerCenter". HOW TO RUN INFORMATICA WORKFLOW USING UNIX COMMAND How to run Informatica Workflow using Unix command. To run the workflow first need to got the command line and go to the folder where the executable is installed. Mostly you can find the pmcmd command in \server\bin\directory. IBM COGNOS FRAMEWORK MANAGER IBM Cognos Framework Manager is the IBM Cognos BI modeling tool for creating and managing business related metadata for use in IBM Cognos BI analysis and reporting.IBM Cognos Framework Manager is the metadatamodel development
JOINS IN ORACLE-DIFFERENT JOINS IN ORACLE WITH EXAMPLES 3. If a join involves in more than two tables then Oracle joins first two tables based on the joins condition and then compares the result with the next table and so on. DIFFERENCE BETWEEN ROUTER AND FILTER TRANSFORMATION IN Router transformation provides us the facility to capture the rows of data that do not meet any of the conditions to a default output group. A Filter transformation tests data for one condition and drops the rows of data that do not meet the condition. Router transformation is a single input and multi output group transformation. PIG VS HIVE: MAIN DIFFERENCES BETWEEN APACHE PIG AND HIVE Pig was created by researchers at Yahoo, and has the flexibility of multiple query approach. Although somewhat similar to SQL the traditional language for data analysis in some ways, doesn’t have its declarative nature and has limitations like- being dependent on relational database schemas. DATAWAREHOUSE CONCEPTS Microsoft Power BI is used to find insights within an organization's data. Power BI is popular for its versatility, interactivity, aesthetic designs, extensive connectivity to databases and ease of creating low-effort dashboards and also provides multiple software connectors and services. OCI EXAM QUESTION & ANSWERS 1. Which Oracle Cloud Infrastructure (OCI) service can send you an alert when you might exceed your spending threshold? A. Budgets B.Monito
SCD TYPE 2,SLOWLY CHANGING DIMENSION USE,EXAMPLE,ADVANTAGE In Type 2 Slowly Changing Dimension, a new record is added to the table to represent the new information. Therefore, both the original and the new record will be present. INFORMATICA SCENARIO: HOW TO LOAD DATA IN CYCLIC ORDER In this scenario we will load the records present in the DEP table to Flat files in a cyclic order such that the first record will go to TargetFile01 ,2 nd to TargetFile 02 ,3 rd to Target File03 and 4 th record again to TargetFile01. AUDIT COLUMNS IN DATAWAREHOUSE In data warehouse and data marts we maintain timestamp columns like “Last_Modified_Date or Created_Date” to track the exact date and time when the records were updated or inserted.These columns are called Audit Columns. But audit columns won’t track the deletion of columns. Last modified date stores the timestamp for record when it was modified for the last time and Created SOURCE QUALIFIER VERSUS JOINER TRANSFORMATION When a mapping uses related relational sources, you can join both sources in one Source Qualifier transformation. During the session, the source database performs the join before passing data to the Integration Service. HOW TO CONFIGURE EMAIL TASK IN INFORMATICA WITH EXAMPLES Email task is used to send emails while running the workflow.Using email task we can get failure and success notifications To expla INFORMATICA POWERCENTER SESSION PARTITIONING-TYPE OF We can either go for Dynamic partitioning (number of partition passed as parameter) or Non-dynamic partition (number of partition are fixed while coding). Apart from used for optimizing the session, Informatica partition become useful in situations where we need to load huge volume of data or when we are using Informatica source which already has partitions defined, and using those partitions HOW TO RUN INFORMATICA WORKFLOW USING UNIX COMMAND To run the workflow first need to got the command line and go to the folder where the executable is installed. Mostly you can find the pmcmd command in \server\bin\directory. PIG VS HIVE: MAIN DIFFERENCES BETWEEN APACHE PIG AND HIVE Pig was created by researchers at Yahoo, and has the flexibility of multiple query approach. Although somewhat similar to SQL the traditional language for data analysis in some ways, doesn’t have its declarative nature and has limitations like- being dependent on relational database schemas. DATAWAREHOUSE CONCEPTS Microsoft Power BI is used to find insights within an organization's data. Power BI is popular for its versatility, interactivity, aesthetic designs, extensive connectivity to databases and ease of creating low-effort dashboards and also provides multiple software connectors and services. OCI EXAM QUESTION & ANSWERS 1. Which Oracle Cloud Infrastructure (OCI) service can send you an alert when you might exceed your spending threshold? A. Budgets B.Monito
SCD TYPE 2,SLOWLY CHANGING DIMENSION USE,EXAMPLE,ADVANTAGE In Type 2 Slowly Changing Dimension, a new record is added to the table to represent the new information. Therefore, both the original and the new record will be present. INFORMATICA SCENARIO: HOW TO LOAD DATA IN CYCLIC ORDER In this scenario we will load the records present in the DEP table to Flat files in a cyclic order such that the first record will go to TargetFile01 ,2 nd to TargetFile 02 ,3 rd to Target File03 and 4 th record again to TargetFile01. AUDIT COLUMNS IN DATAWAREHOUSE In data warehouse and data marts we maintain timestamp columns like “Last_Modified_Date or Created_Date” to track the exact date and time when the records were updated or inserted.These columns are called Audit Columns. But audit columns won’t track the deletion of columns. Last modified date stores the timestamp for record when it was modified for the last time and Created SOURCE QUALIFIER VERSUS JOINER TRANSFORMATION When a mapping uses related relational sources, you can join both sources in one Source Qualifier transformation. During the session, the source database performs the join before passing data to the Integration Service. HOW TO CONFIGURE EMAIL TASK IN INFORMATICA WITH EXAMPLES Email task is used to send emails while running the workflow.Using email task we can get failure and success notifications To expla INFORMATICA POWERCENTER SESSION PARTITIONING-TYPE OF We can either go for Dynamic partitioning (number of partition passed as parameter) or Non-dynamic partition (number of partition are fixed while coding). Apart from used for optimizing the session, Informatica partition become useful in situations where we need to load huge volume of data or when we are using Informatica source which already has partitions defined, and using those partitions HOW TO RUN INFORMATICA WORKFLOW USING UNIX COMMAND To run the workflow first need to got the command line and go to the folder where the executable is installed. Mostly you can find the pmcmd command in \server\bin\directory. PIG VS HIVE: MAIN DIFFERENCES BETWEEN APACHE PIG AND HIVE Pig was created by researchers at Yahoo, and has the flexibility of multiple query approach. Although somewhat similar to SQL the traditional language for data analysis in some ways, doesn’t have its declarative nature and has limitations like- being dependent on relational database schemas. OCI EXAM QUESTION & ANSWERS 1. Which Oracle Cloud Infrastructure (OCI) service can be used to protect sensitive and regulated data in OCI database services? A. Orac REQUIREMENTS GATHERING PHASE(HLD & LLD) IN DATA WAREHOUSE GAP Analysis: This is the comparison between client requirement and reporting tool features like is the tool fulfill all the requirements of the client or not.; POC(Proof of Concept): This is the dummy or a duplicate model where the development team will cook the data manually and prepares a sample model which is going to send for the client'sapproval.
AUDIT COLUMNS IN DATAWAREHOUSE In data warehouse and data marts we maintain timestamp columns like “Last_Modified_Date or Created_Date” to track the exact date and time when the records were updated or inserted.These columns are called Audit Columns. But audit columns won’t track the deletion of columns. Last modified date stores the timestamp for record when it was modified for the last time and Created SCD TYPE 3,SLOWLY CHANGING DIMENSION USE,EXAMPLE,ADVANTAGE In Type 3 Slowly Changing Dimension, there will be two columns to indicate the particular attribute of interest, one indicating the original value, and one indicating the current value. DIMENSION HIERARCHIES IN OBIEE:LEVEL-BASED HIERARCHY AND Un balanced (or ragged) hierarchy : A hierarchy in which all the lowest-level members do not have the same depth For example, a site can choose to have data for the current month at the day level, previous months data at the month level, and the previous 5 years data at the quarter level.; For example, a Time hierarchy might have data for the current month at the day level, the previous month DYNAMIC AND STATIC CACHE IN INFORMATICA In Uncached lookup we do lookup on the base table and will return output values based on the Lookup condition. If the lookup condition is matching it returns the value from Lookup table or cache .And if lookup condition is not satisfied then it returns either NULL ordefault value.
DIFFERENCE BETWEEN ROUTER AND FILTER TRANSFORMATION IN Better Performance; because in mapping, the Router transformation Informatica server processes the input data only once instead of as many times as you have conditions in Filter transformation.; Less complexity; because we use only one Router transformation instead of multiple Filter transformation.; Router transformation is more efficient than the Filter transformation. JOINS IN ORACLE-DIFFERENT JOINS IN ORACLE WITH EXAMPLES 3. If a join involves in more than two tables then Oracle joins first two tables based on the joins condition and then compares the result with the next table and so on. PIG VS HIVE: MAIN DIFFERENCES BETWEEN APACHE PIG AND HIVE Pig was created by researchers at Yahoo, and has the flexibility of multiple query approach. Although somewhat similar to SQL the traditional language for data analysis in some ways, doesn’t have its declarative nature and has limitations like- being dependent on relational database schemas. WRITE-BACK LIMITATIONS IN OBIEE Users can write back to any data source (except for an ADF data source) that allows the execution of SQL queries from the Oracle BI Server. As you configure for write back, keep the following limitations in mind: DATAWAREHOUSE CONCEPTS Power BI is popular for its versatility, interactivity, aesthetic designs, extensive connectivity to databases and ease of creating low-effort dashboards and also provides multiple software connectors and services. Power BI can generate custom dashboards depending on what data is relevant, and what information you need access to. WHAT IS A FACTLESS FACT TABLE?WHERE WE USE Factless fact tables for Events The first type of factless fact table is a table that records an event. Many event-tracking tables in dimensional data warehouses turn out to be factless.Sometimes there seem to be no facts associated with an important business process.Events or activities occur that you wish to track, but you find no measurements. INFORMATICA SCENARIO: HOW TO LOAD DATA IN CYCLIC ORDER In this scenario we will load the records present in the DEP table to Flat files in a cyclic order such that the first record will go to TargetFile01 ,2 nd to TargetFile 02 ,3 rd to Target File03 and 4 th record again to TargetFile01. SCD TYPE 2,SLOWLY CHANGING DIMENSION USE,EXAMPLE,ADVANTAGE In Type 2 Slowly Changing Dimension, a new record is added to the table to represent the new information. Therefore, both the original and the new record will be present. HOW TO GENERATE DYNAMIC TARGET FILE IN INFORMATICA BASED 3. Now we need to connect the Expression Transformation to TransactionControl transformation.Informatica Power Centre allows us to control the roll back and commit on transaction based on set of rows that passes through the TransactionControl transformation.This allows to define your transaction whether it should be committed or rollback based on the rows that pass through, HOW TO CONFIGURE EMAIL TASK IN INFORMATICA WITH EXAMPLES Email task is used to send emails while running the workflow.Using email task we can get failure and success notifications. To explain this lets take the example of a workflow with two sessions.Session1 and Session2. a)Go to create task and create an Email Task and name it as Test_email. b)Also Enter the following details. SOURCE QUALIFIER VERSUS JOINER TRANSFORMATION When a mapping uses related relational sources, you can join both sources in one Source Qualifier transformation. During the session, the source database performs the join before passing data to the Integration Service. REGRESSION TESTING PHASE IN ETL TESTING The steps are, Ensure that current functionality stays intact whenever new code is released HOW TO UNLOCK THE LOCKED TABLE IN ORACLE What you presented is a theoretical scenario for a system with very few users and little activity. In real life there are systems with multiple DMLs going on in parallel so while you kill off the sessions currently holding locks on your object, you will get new sessions getting locks before you are through with your loop. WRITE-BACK LIMITATIONS IN OBIEE Write-Back Limitations in OBIEE. Users can write back to any data source (except for an ADF data source) that allows the execution of SQL queries from the Oracle BI Server. As you configure for write back, keep the following limitations in mind: Numeric columns must contain numbers only. DATAWAREHOUSE CONCEPTS Power BI is popular for its versatility, interactivity, aesthetic designs, extensive connectivity to databases and ease of creating low-effort dashboards and also provides multiple software connectors and services. Power BI can generate custom dashboards depending on what data is relevant, and what information you need access to. WHAT IS A FACTLESS FACT TABLE?WHERE WE USE Factless fact tables for Events The first type of factless fact table is a table that records an event. Many event-tracking tables in dimensional data warehouses turn out to be factless.Sometimes there seem to be no facts associated with an important business process.Events or activities occur that you wish to track, but you find no measurements. INFORMATICA SCENARIO: HOW TO LOAD DATA IN CYCLIC ORDER In this scenario we will load the records present in the DEP table to Flat files in a cyclic order such that the first record will go to TargetFile01 ,2 nd to TargetFile 02 ,3 rd to Target File03 and 4 th record again to TargetFile01. SCD TYPE 2,SLOWLY CHANGING DIMENSION USE,EXAMPLE,ADVANTAGE In Type 2 Slowly Changing Dimension, a new record is added to the table to represent the new information. Therefore, both the original and the new record will be present. HOW TO GENERATE DYNAMIC TARGET FILE IN INFORMATICA BASED 3. Now we need to connect the Expression Transformation to TransactionControl transformation.Informatica Power Centre allows us to control the roll back and commit on transaction based on set of rows that passes through the TransactionControl transformation.This allows to define your transaction whether it should be committed or rollback based on the rows that pass through, HOW TO CONFIGURE EMAIL TASK IN INFORMATICA WITH EXAMPLES Email task is used to send emails while running the workflow.Using email task we can get failure and success notifications. To explain this lets take the example of a workflow with two sessions.Session1 and Session2. a)Go to create task and create an Email Task and name it as Test_email. b)Also Enter the following details. SOURCE QUALIFIER VERSUS JOINER TRANSFORMATION When a mapping uses related relational sources, you can join both sources in one Source Qualifier transformation. During the session, the source database performs the join before passing data to the Integration Service. REGRESSION TESTING PHASE IN ETL TESTING The steps are, Ensure that current functionality stays intact whenever new code is released HOW TO UNLOCK THE LOCKED TABLE IN ORACLE What you presented is a theoretical scenario for a system with very few users and little activity. In real life there are systems with multiple DMLs going on in parallel so while you kill off the sessions currently holding locks on your object, you will get new sessions getting locks before you are through with your loop. WRITE-BACK LIMITATIONS IN OBIEE Write-Back Limitations in OBIEE. Users can write back to any data source (except for an ADF data source) that allows the execution of SQL queries from the Oracle BI Server. As you configure for write back, keep the following limitations in mind: Numeric columns must contain numbers only. HOW TO CONFIGURE EMAIL TASK IN INFORMATICA WITH EXAMPLES Email task is used to send emails while running the workflow.Using email task we can get failure and success notifications. To explain this lets take the example of a workflow with two sessions.Session1 and Session2. a)Go to create task and create an Email Task and name it as Test_email. b)Also Enter the following details. SCD TYPE 3,SLOWLY CHANGING DIMENSION USE,EXAMPLE,ADVANTAGE SCD Type 3,Slowly Changing Dimension Use,Example,Advantage,Disadvantage. In Type 3 Slowly Changing Dimension, there will be two columns to indicate the particular attribute of interest, one indicating the original value, and one indicating the current value. There will also be a column that indicates when the current value becomes active. AUDIT COLUMNS IN DATAWAREHOUSE Audit Columns in Datawarehouse. In data warehouse and data marts we maintain timestamp columns like “Last_Modified_Date or Created_Date” to track the exact date and time when the records were updated or inserted.These columns are called Audit Columns. But audit columns won’t track the deletion of columns. DIMENSION HIERARCHIES IN OBIEE:LEVEL-BASED HIERARCHY AND A parent-child hierarchy is a hierarchy of members that all have the same type.It is a value-based hierarchy — Consists of values that define the hierarchy in a parent-child relationship and does not contain named levels. This contrasts with level-based hierarchies, where members of the same type occur only at a single level of thehierarchy.
IBM COGNOS FRAMEWORK MANAGER IBM Cognos Framework Manager is the IBM Cognos BI modeling tool for creating and managing business related metadata for use in IBM Cognos BI analysis and reporting.IBM Cognos Framework Manager is the metadata model development environment for IBM Cognos BI. It is a Windows-based client tool that you can use to create simplified business REQUIREMENTS GATHERING PHASE(HLD & LLD) IN DATA WAREHOUSE Requirements Gathering Phase (HLD & LLD) in Data Warehouse Project Life Cycle. Business Analyst (BA): He is the person or a mediator between the client and the organization. First Business Analyst is going to interact with the client to know about the client business and pain-areas, from that business analysis BA will prepare thedocument
JOINS IN ORACLE-DIFFERENT JOINS IN ORACLE WITH EXAMPLES 3. If a join involves in more than two tables then Oracle joins first two tables based on the joins condition and then compares the result with the next table and so on. HOW TO UNLOCK THE LOCKED TABLE IN ORACLE What you presented is a theoretical scenario for a system with very few users and little activity. In real life there are systems with multiple DMLs going on in parallel so while you kill off the sessions currently holding locks on your object, you will get new sessions getting locks before you are through with your loop. WRITE-BACK LIMITATIONS IN OBIEE Write-Back Limitations in OBIEE. Users can write back to any data source (except for an ADF data source) that allows the execution of SQL queries from the Oracle BI Server. As you configure for write back, keep the following limitations in mind: Numeric columns must contain numbers only. PIG VS HIVE: MAIN DIFFERENCES BETWEEN APACHE PIG AND HIVE Pig was created by researchers at Yahoo, and has the flexibility of multiple query approach. Although somewhat similar to SQL the traditional language for data analysis in some ways, doesn’t have its declarative nature and has limitations like- being dependent on relational database schemas. DATAWAREHOUSE CONCEPTS Power BI is popular for its versatility, interactivity, aesthetic designs, extensive connectivity to databases and ease of creating low-effort dashboards and also provides multiple software connectors and services. Power BI can generate custom dashboards depending on what data is relevant, and what information you need access to. WHAT IS A FACTLESS FACT TABLE?WHERE WE USE Factless fact tables for Events The first type of factless fact table is a table that records an event. Many event-tracking tables in dimensional data warehouses turn out to be factless.Sometimes there seem to be no facts associated with an important business process.Events or activities occur that you wish to track, but you find no measurements. INFORMATICA SCENARIO: HOW TO LOAD DATA IN CYCLIC ORDER In this scenario we will load the records present in the DEP table to Flat files in a cyclic order such that the first record will go to TargetFile01 ,2 nd to TargetFile 02 ,3 rd to Target File03 and 4 th record again to TargetFile01. SCD TYPE 2,SLOWLY CHANGING DIMENSION USE,EXAMPLE,ADVANTAGE In Type 2 Slowly Changing Dimension, a new record is added to the table to represent the new information. Therefore, both the original and the new record will be present. HOW TO GENERATE DYNAMIC TARGET FILE IN INFORMATICA BASED 3. Now we need to connect the Expression Transformation to TransactionControl transformation.Informatica Power Centre allows us to control the roll back and commit on transaction based on set of rows that passes through the TransactionControl transformation.This allows to define your transaction whether it should be committed or rollback based on the rows that pass through, HOW TO CONFIGURE EMAIL TASK IN INFORMATICA WITH EXAMPLES Email task is used to send emails while running the workflow.Using email task we can get failure and success notifications. To explain this lets take the example of a workflow with two sessions.Session1 and Session2. a)Go to create task and create an Email Task and name it as Test_email. b)Also Enter the following details. SOURCE QUALIFIER VERSUS JOINER TRANSFORMATION When a mapping uses related relational sources, you can join both sources in one Source Qualifier transformation. During the session, the source database performs the join before passing data to the Integration Service. REGRESSION TESTING PHASE IN ETL TESTING The steps are, Ensure that current functionality stays intact whenever new code is released HOW TO UNLOCK THE LOCKED TABLE IN ORACLE What you presented is a theoretical scenario for a system with very few users and little activity. In real life there are systems with multiple DMLs going on in parallel so while you kill off the sessions currently holding locks on your object, you will get new sessions getting locks before you are through with your loop. WRITE-BACK LIMITATIONS IN OBIEE Write-Back Limitations in OBIEE. Users can write back to any data source (except for an ADF data source) that allows the execution of SQL queries from the Oracle BI Server. As you configure for write back, keep the following limitations in mind: Numeric columns must contain numbers only. DATAWAREHOUSE CONCEPTS Power BI is popular for its versatility, interactivity, aesthetic designs, extensive connectivity to databases and ease of creating low-effort dashboards and also provides multiple software connectors and services. Power BI can generate custom dashboards depending on what data is relevant, and what information you need access to. WHAT IS A FACTLESS FACT TABLE?WHERE WE USE Factless fact tables for Events The first type of factless fact table is a table that records an event. Many event-tracking tables in dimensional data warehouses turn out to be factless.Sometimes there seem to be no facts associated with an important business process.Events or activities occur that you wish to track, but you find no measurements. INFORMATICA SCENARIO: HOW TO LOAD DATA IN CYCLIC ORDER In this scenario we will load the records present in the DEP table to Flat files in a cyclic order such that the first record will go to TargetFile01 ,2 nd to TargetFile 02 ,3 rd to Target File03 and 4 th record again to TargetFile01. SCD TYPE 2,SLOWLY CHANGING DIMENSION USE,EXAMPLE,ADVANTAGE In Type 2 Slowly Changing Dimension, a new record is added to the table to represent the new information. Therefore, both the original and the new record will be present. HOW TO GENERATE DYNAMIC TARGET FILE IN INFORMATICA BASED 3. Now we need to connect the Expression Transformation to TransactionControl transformation.Informatica Power Centre allows us to control the roll back and commit on transaction based on set of rows that passes through the TransactionControl transformation.This allows to define your transaction whether it should be committed or rollback based on the rows that pass through, HOW TO CONFIGURE EMAIL TASK IN INFORMATICA WITH EXAMPLES Email task is used to send emails while running the workflow.Using email task we can get failure and success notifications. To explain this lets take the example of a workflow with two sessions.Session1 and Session2. a)Go to create task and create an Email Task and name it as Test_email. b)Also Enter the following details. SOURCE QUALIFIER VERSUS JOINER TRANSFORMATION When a mapping uses related relational sources, you can join both sources in one Source Qualifier transformation. During the session, the source database performs the join before passing data to the Integration Service. REGRESSION TESTING PHASE IN ETL TESTING The steps are, Ensure that current functionality stays intact whenever new code is released HOW TO UNLOCK THE LOCKED TABLE IN ORACLE What you presented is a theoretical scenario for a system with very few users and little activity. In real life there are systems with multiple DMLs going on in parallel so while you kill off the sessions currently holding locks on your object, you will get new sessions getting locks before you are through with your loop. WRITE-BACK LIMITATIONS IN OBIEE Write-Back Limitations in OBIEE. Users can write back to any data source (except for an ADF data source) that allows the execution of SQL queries from the Oracle BI Server. As you configure for write back, keep the following limitations in mind: Numeric columns must contain numbers only. OCI EXAM QUESTION & ANSWERS 1. Which Oracle Cloud Infrastructure (OCI) service can send you an alert when you might exceed your spending threshold? A. Budgets B.Monito
HOW TO CONFIGURE EMAIL TASK IN INFORMATICA WITH EXAMPLES Email task is used to send emails while running the workflow.Using email task we can get failure and success notifications. To explain this lets take the example of a workflow with two sessions.Session1 and Session2. a)Go to create task and create an Email Task and name it as Test_email. b)Also Enter the following details. AUDIT COLUMNS IN DATAWAREHOUSE Audit Columns in Datawarehouse. In data warehouse and data marts we maintain timestamp columns like “Last_Modified_Date or Created_Date” to track the exact date and time when the records were updated or inserted.These columns are called Audit Columns. But audit columns won’t track the deletion of columns. SCD TYPE 3,SLOWLY CHANGING DIMENSION USE,EXAMPLE,ADVANTAGE SCD Type 3,Slowly Changing Dimension Use,Example,Advantage,Disadvantage. In Type 3 Slowly Changing Dimension, there will be two columns to indicate the particular attribute of interest, one indicating the original value, and one indicating the current value. There will also be a column that indicates when the current value becomes active. REQUIREMENTS GATHERING PHASE(HLD & LLD) IN DATA WAREHOUSE Requirements Gathering Phase (HLD & LLD) in Data Warehouse Project Life Cycle. Business Analyst (BA): He is the person or a mediator between the client and the organization. First Business Analyst is going to interact with the client to know about the client business and pain-areas, from that business analysis BA will prepare thedocument
IBM COGNOS FRAMEWORK MANAGER IBM Cognos Framework Manager is the IBM Cognos BI modeling tool for creating and managing business related metadata for use in IBM Cognos BI analysis and reporting.IBM Cognos Framework Manager is the metadata model development environment for IBM Cognos BI. It is a Windows-based client tool that you can use to create simplified business HOW TO UNLOCK THE LOCKED TABLE IN ORACLE What you presented is a theoretical scenario for a system with very few users and little activity. In real life there are systems with multiple DMLs going on in parallel so while you kill off the sessions currently holding locks on your object, you will get new sessions getting locks before you are through with your loop. JOINS IN ORACLE-DIFFERENT JOINS IN ORACLE WITH EXAMPLES 3. If a join involves in more than two tables then Oracle joins first two tables based on the joins condition and then compares the result with the next table and so on. WRITE-BACK LIMITATIONS IN OBIEE Write-Back Limitations in OBIEE. Users can write back to any data source (except for an ADF data source) that allows the execution of SQL queries from the Oracle BI Server. As you configure for write back, keep the following limitations in mind: Numeric columns must contain numbers only. PIG VS HIVE: MAIN DIFFERENCES BETWEEN APACHE PIG AND HIVE Pig was created by researchers at Yahoo, and has the flexibility of multiple query approach. Although somewhat similar to SQL the traditional language for data analysis in some ways, doesn’t have its declarative nature and has limitations like- being dependent on relational database schemas. DATAWAREHOUSE CONCEPTS Power BI is popular for its versatility, interactivity, aesthetic designs, extensive connectivity to databases and ease of creating low-effort dashboards and also provides multiple software connectors and services. Power BI can generate custom dashboards depending on what data is relevant, and what information you need access to. WHAT IS A FACTLESS FACT TABLE?WHERE WE USE Factless fact tables for Events The first type of factless fact table is a table that records an event. Many event-tracking tables in dimensional data warehouses turn out to be factless.Sometimes there seem to be no facts associated with an important business process.Events or activities occur that you wish to track, but you find no measurements. INFORMATICA SCENARIO: HOW TO LOAD DATA IN CYCLIC ORDER In this scenario we will load the records present in the DEP table to Flat files in a cyclic order such that the first record will go to TargetFile01 ,2 nd to TargetFile 02 ,3 rd to Target File03 and 4 th record again to TargetFile01. SCD TYPE 2,SLOWLY CHANGING DIMENSION USE,EXAMPLE,ADVANTAGE In Type 2 Slowly Changing Dimension, a new record is added to the table to represent the new information. Therefore, both the original and the new record will be present. HOW TO GENERATE DYNAMIC TARGET FILE IN INFORMATICA BASED 3. Now we need to connect the Expression Transformation to TransactionControl transformation.Informatica Power Centre allows us to control the roll back and commit on transaction based on set of rows that passes through the TransactionControl transformation.This allows to define your transaction whether it should be committed or rollback based on the rows that pass through, HOW TO CONFIGURE EMAIL TASK IN INFORMATICA WITH EXAMPLES Email task is used to send emails while running the workflow.Using email task we can get failure and success notifications. To explain this lets take the example of a workflow with two sessions.Session1 and Session2. a)Go to create task and create an Email Task and name it as Test_email. b)Also Enter the following details. SOURCE QUALIFIER VERSUS JOINER TRANSFORMATION When a mapping uses related relational sources, you can join both sources in one Source Qualifier transformation. During the session, the source database performs the join before passing data to the Integration Service. REGRESSION TESTING PHASE IN ETL TESTING The steps are, Ensure that current functionality stays intact whenever new code is released HOW TO UNLOCK THE LOCKED TABLE IN ORACLE What you presented is a theoretical scenario for a system with very few users and little activity. In real life there are systems with multiple DMLs going on in parallel so while you kill off the sessions currently holding locks on your object, you will get new sessions getting locks before you are through with your loop. WRITE-BACK LIMITATIONS IN OBIEE Write-Back Limitations in OBIEE. Users can write back to any data source (except for an ADF data source) that allows the execution of SQL queries from the Oracle BI Server. As you configure for write back, keep the following limitations in mind: Numeric columns must contain numbers only. DATAWAREHOUSE CONCEPTS Power BI is popular for its versatility, interactivity, aesthetic designs, extensive connectivity to databases and ease of creating low-effort dashboards and also provides multiple software connectors and services. Power BI can generate custom dashboards depending on what data is relevant, and what information you need access to. WHAT IS A FACTLESS FACT TABLE?WHERE WE USE Factless fact tables for Events The first type of factless fact table is a table that records an event. Many event-tracking tables in dimensional data warehouses turn out to be factless.Sometimes there seem to be no facts associated with an important business process.Events or activities occur that you wish to track, but you find no measurements. INFORMATICA SCENARIO: HOW TO LOAD DATA IN CYCLIC ORDER In this scenario we will load the records present in the DEP table to Flat files in a cyclic order such that the first record will go to TargetFile01 ,2 nd to TargetFile 02 ,3 rd to Target File03 and 4 th record again to TargetFile01. SCD TYPE 2,SLOWLY CHANGING DIMENSION USE,EXAMPLE,ADVANTAGE In Type 2 Slowly Changing Dimension, a new record is added to the table to represent the new information. Therefore, both the original and the new record will be present. HOW TO GENERATE DYNAMIC TARGET FILE IN INFORMATICA BASED 3. Now we need to connect the Expression Transformation to TransactionControl transformation.Informatica Power Centre allows us to control the roll back and commit on transaction based on set of rows that passes through the TransactionControl transformation.This allows to define your transaction whether it should be committed or rollback based on the rows that pass through, HOW TO CONFIGURE EMAIL TASK IN INFORMATICA WITH EXAMPLES Email task is used to send emails while running the workflow.Using email task we can get failure and success notifications. To explain this lets take the example of a workflow with two sessions.Session1 and Session2. a)Go to create task and create an Email Task and name it as Test_email. b)Also Enter the following details. SOURCE QUALIFIER VERSUS JOINER TRANSFORMATION When a mapping uses related relational sources, you can join both sources in one Source Qualifier transformation. During the session, the source database performs the join before passing data to the Integration Service. REGRESSION TESTING PHASE IN ETL TESTING The steps are, Ensure that current functionality stays intact whenever new code is released HOW TO UNLOCK THE LOCKED TABLE IN ORACLE What you presented is a theoretical scenario for a system with very few users and little activity. In real life there are systems with multiple DMLs going on in parallel so while you kill off the sessions currently holding locks on your object, you will get new sessions getting locks before you are through with your loop. WRITE-BACK LIMITATIONS IN OBIEE Write-Back Limitations in OBIEE. Users can write back to any data source (except for an ADF data source) that allows the execution of SQL queries from the Oracle BI Server. As you configure for write back, keep the following limitations in mind: Numeric columns must contain numbers only. OCI EXAM QUESTION & ANSWERS 1. Which Oracle Cloud Infrastructure (OCI) service can send you an alert when you might exceed your spending threshold? A. Budgets B.Monito
HOW TO CONFIGURE EMAIL TASK IN INFORMATICA WITH EXAMPLES Email task is used to send emails while running the workflow.Using email task we can get failure and success notifications. To explain this lets take the example of a workflow with two sessions.Session1 and Session2. a)Go to create task and create an Email Task and name it as Test_email. b)Also Enter the following details. AUDIT COLUMNS IN DATAWAREHOUSE Audit Columns in Datawarehouse. In data warehouse and data marts we maintain timestamp columns like “Last_Modified_Date or Created_Date” to track the exact date and time when the records were updated or inserted.These columns are called Audit Columns. But audit columns won’t track the deletion of columns. SCD TYPE 3,SLOWLY CHANGING DIMENSION USE,EXAMPLE,ADVANTAGE SCD Type 3,Slowly Changing Dimension Use,Example,Advantage,Disadvantage. In Type 3 Slowly Changing Dimension, there will be two columns to indicate the particular attribute of interest, one indicating the original value, and one indicating the current value. There will also be a column that indicates when the current value becomes active. REQUIREMENTS GATHERING PHASE(HLD & LLD) IN DATA WAREHOUSE Requirements Gathering Phase (HLD & LLD) in Data Warehouse Project Life Cycle. Business Analyst (BA): He is the person or a mediator between the client and the organization. First Business Analyst is going to interact with the client to know about the client business and pain-areas, from that business analysis BA will prepare thedocument
IBM COGNOS FRAMEWORK MANAGER IBM Cognos Framework Manager is the IBM Cognos BI modeling tool for creating and managing business related metadata for use in IBM Cognos BI analysis and reporting.IBM Cognos Framework Manager is the metadata model development environment for IBM Cognos BI. It is a Windows-based client tool that you can use to create simplified business HOW TO UNLOCK THE LOCKED TABLE IN ORACLE What you presented is a theoretical scenario for a system with very few users and little activity. In real life there are systems with multiple DMLs going on in parallel so while you kill off the sessions currently holding locks on your object, you will get new sessions getting locks before you are through with your loop. JOINS IN ORACLE-DIFFERENT JOINS IN ORACLE WITH EXAMPLES 3. If a join involves in more than two tables then Oracle joins first two tables based on the joins condition and then compares the result with the next table and so on. WRITE-BACK LIMITATIONS IN OBIEE Write-Back Limitations in OBIEE. Users can write back to any data source (except for an ADF data source) that allows the execution of SQL queries from the Oracle BI Server. As you configure for write back, keep the following limitations in mind: Numeric columns must contain numbers only. PIG VS HIVE: MAIN DIFFERENCES BETWEEN APACHE PIG AND HIVE Pig was created by researchers at Yahoo, and has the flexibility of multiple query approach. Although somewhat similar to SQL the traditional language for data analysis in some ways, doesn’t have its declarative nature and has limitations like- being dependent on relational database schemas. DATAWAREHOUSE CONCEPTS A blog where you can explore everything about Datawarehouse,OBIEE,Informatica,Hadoop,Oracle SQL-PLSQL,Cognos andmuch more....
PAGES
* HOME
* OBIEE
* INFORMATICA
* SQL
* INFORMATICA SCENARIOS* HADOOP
* CLOUD COMPUTING
* UNIX
* DATASTAGE
* ORACLE
* TERADATA
* COGNOS
* SAS
* BO
* BIG DATA
THURSDAY, 26 APRIL 2018 HDFS: USEFUL HADOOP ADMIN COMMANDS HDFS is designed more for batch processing rather than interactive use by users. The emphasis is on high throughput of data access rather than low latency of data access. Applications that run on HDFS have large data sets. A typical file in HDFS is gigabytes to terabytes in size. Thus, HDFS is tuned to supportlarge files.
HDFS categorises its data in files and directories.It provides a command line interface called the FS shell that lets the user interact with data in the HDFS and manage your hadoop cluster. This article provides a quick handy reference to all commonly used hadoop fs commands that can be used to manage files on a Hadoop cluster.The syntax of the commands is similar to bash and csh. CHECK MORE ABOUT -HDFSAND MAPREDUCE File transferring from local to HDFSHadoop fs –put
File transferring from HDFS to LocalHadoop fs –get
File transferring within the HDFSHadoop fs –cp
List of the File Display inside the HDFSHadoop fs –ls
Display the content in the File within HDFSHadoop fs –cat
Remove particular File in HDFSHadoop fs –rm
Remove File directory in HDFSHadoop fs –rmr
Display the File size Hadoop fs –duHadoop fsck
File transferring from local to HDFS Hadoop fs -CopyFromLocal File transferring from HDFS to Local Hadoop fs –CopyToLocalat 21:09:00
63 comments:
Links to this post
Labels: Big Data
, Hadoop
, HDFS
, MapReduce
SUNDAY, 18 MARCH 2018 WHAT ARE THE TYPES OF PI (PRIMARY INDEX) IN TERADATA? The TERADATA PRIMARY INDEX is not an index in the traditional sense, as it is not a lookup table. Instead, it is a mechanism that defines where each data row is physically located on the Teradata system. The primary index of a table may be defined as either a single column or as multiple columns. The values of the primary index columns within the table may be unique or non-unique. The Primary Index of a table should not be confused with the primary key of a table.The primary index is a part of the physical database model, and affects the storage and retrieval of data rows. The primary key is a part of the logical database model, and uniquely identifies each record in the table. Often, the primary key of a table is a good candidate for the primary index of a table, particularly for smaller “dimension” or “lookup” tables, but this is not always the case for other tables. There are two types of Primary Index. UNIQUE PRIMARY INDEX ( UPI) and NON UNIQUE PRIMARY INDEX (NUPI). By default, NUPI is created when the table is created. Unique keyword has to be explicitly given when UPIhas to be created.
UPI will slower the performance sometimes as for each and every row , uniqueness of the column value has to be checked and it is an additional overhead to the system but the distribution of data will beeven.
We should be careful while choosing a NUPI so that the distribution of data is almost even . UPI/NUPI decision should be taken based on the data and its usage.at 10:15:00
263 comments:
Links to this post
Labels: Database
, Teradata
Older Posts
Home
Subscribe to: Posts (Atom)SHARETHIS
Kashinathan
on Google+
Follow @KashinathankLIVE TRAFFIC
Feedjit Live Blog StatsSUBSCRIBE TO
Posts
Atom
Posts
All Comments
Atom
All Comments
FOLLOW BY EMAIL
FOLLOWERS
POPULAR POSTS
* Types of Dimensions * What is a FACTLESS FACT TABLE?Where we use Factless Fact * JOINS IN ORACLE-different joins in oracle with examples * How to Unlock the Locked Table in ORACLE * What is a PARTITION in Oracle?Why to use Partition And Types ofPartitions
* How to Drop Indexes/ Unique Indexes in Oracle? * SCD Type 1, SCD Type 2, SCD Type 3,Slowly Changing Dimension Types,Advantages & Disadvantages * Informatica PowerCenter Session Partitioning-Type of InformaticaPartitions
* What are the types of PI (Primary Index) in Teradata?SEARCH THIS BLOG
MOST DISCUSSED POST
JOINS IN ORACLE-DIFFERENT JOINS IN ORACLE WITH EXAMPLES 1. The purpose of a join is to combine the data across tables. 2 . A join is actually performed by the where clause which combi...COMMENTS BOX
*
BITSINDRINice explanation. I was looking for diff…*
USMANQuickBooks software is used by the vario…*
EASYLEARNHi,Best article, very useful and well ex…*
BUSINESS IDEAS FOR WOMENThis is a great example of the type of b…*
A BUSINESS NAME GENERATORThis comment has been removed by the aut…widget by MS Design
BLOG ARCHIVE
* ▼ 2018 (2)
* ▼ April (1)
* HDFS: Useful Hadoop Admin Commands* ► March (1)
* ► 2017 (6)
* ► October (1)* ► July (1)
* ► May (1)
* ► February (1) * ► January (2)* ► 2016 (13)
* ► December (4) * ► November (1) * ► October (2) * ► September (1)* ► June (3)
* ► February (1) * ► January (1)* ► 2015 (7)
* ► October (1)* ► August (1)
* ► June (1)
* ► April (1)
* ► March (1)
* ► February (1) * ► January (1)* ► 2014 (22)
* ► December (1) * ► November (1) * ► October (1) * ► September (2)* ► August (1)
* ► July (2)
* ► June (2)
* ► May (1)
* ► April (2)
* ► March (2)
* ► February (2) * ► January (5)* ► 2013 (104)
* ► December (3) * ► November (7) * ► October (4) * ► September (5) * ► August (10)* ► July (6)
* ► June (6)
* ► May (3)
* ► April (12)
* ► March (9)
* ► February (21) * ► January (18)* ► 2012 (397)
* ► December (32) * ► November (72) * ► October (67) * ► September (90) * ► August (107)* ► July (12)
* ► June (17)
LABELS
Ab Initio
(1) Agents (10)
Aggregator
(8) Amazon Route 53
(1) Amazon's AWS
(1)
Apache AVRO
(2)
Apache Hive
(5)
Artificial Neural Networks(1) Assignment Task
(1)
Atomic Scala
(1)
Avro (1) B-tree
index
(4) bad file
(1)
Balanced hierarchy
(1) BI (3) Big Data(26) Bitmap
Index
(3) BO (4) Buildingthe Data Warehouse
(5) Business Intelligence (27) Business Intelligence Tools (11) Business Model and Mapping layer(2) Cache Manager
(1)
Cassandra
(3) Cloud Computing
(8)
Cloud Dataflow
(1)
CLOUDERA (1)
Cloudera Impala
(1)
Cluster (1)
Cognos (19)
Cognos 10
(15) Conformed dimension (1) Connected Lookup(1)
CONSTRAINTS
(1)
Correlated
(1) CouchDB
(1) Cubes (1)
DAAS (1) DAC
(8) DATA
(1) Data Level
Security
(2) Data Masking
(1)
Data Warehouse Toolkit(1) Database
(5) Database partitioning(3) Datamart
(2) Datastage
(2)
Datawarehouse
(235)
Datawarehouse ebook
(3) Datawarehouse OBIA(1) Date Dimension
(2)
De-serialization
(1)
Debian Linux
(1)
Dimension
(6) DNS (1) Dremel
(1) DWH
(62) Dyn
(1) Dynamic cache
(1)
Dynamic partitioning (1) E-Business Suite(1)
EAM (1) ebook
(2) EBS
(1) edhat
Enterprise Linux
(1) ELT (1) ERP
(1) ETL
(35) FACEBOOK
(3) Fact
(9) Factless Fact
(1)
Fedora Linux
(1)
Filter Transformation (3) Functional Programming (1) Functions in OBIEE (2) Global repository(2) Google (2)
Google Big Query
(3) Google Charts
(1)
Google Cloud
(1)
Google Cloud Storage(1) Hadoop (23)
Hash auto-keys
(2)
Hash user keys
(2)
HBASE (1) HDFS
(1)
Hewlett-Packard's HP-UX(1) Hierarchy
(1) HIVE
(5) Hive QL
(3) HTTP
(1) Hyperion
(5) Hyperion
Financial Reporting
(1) Hyperion Interactive Reporting (1) Hyperion SQR Production Reporting (1) Hyperion Web Analysis(2) IBM (18) iBots
(10) IMPALA
(1) Index
(4) Indexes
(4)
Informatica
(186)
Informatica 9.5
(10)
Informatica Interview Questions (1) Informatica Repository Query (1) Informatica Scenario (2) Informatica Transformations (41) InformaticaScenarios (7) Instanceconfig.xml(1)
Integration Services (2) Internet of Things (2) Interview Q and A (1) INVENTORY_ITEM_ID(1)
IOT (2) java
(1) Joiner
(2) Key range
(2) Kyle
York (1)
Level-Based Hierarchy(1) linux (1)
Local repository
(2)
Logical Dimension
(1) LookupTransformation(2) Mac OS X
(1)
Machine Learning
(2)
Mapping Analyst
(1)
Mappings (5)
MapReduce
(2) Massively parallel processing(3) Measures
(1) Metadata
(1) Microsoft Azure
(1)
Mongo DB 3.4
(1)
MongoDB (4)
MPP (1)
MTL_SYSTEM_ITEMS_B
(1)
Nested Tables
(1)
Netflix (1)
NetSuite (1)
neural nets
(1)
NewSQL (2) NO
SQL (4)
Normalizer transformation(1) NOSQL (5)
NQSConfig.INI
(1) OBIA
(66) OBIEE
(142) OBIEE 10g
(129)
OBIEE 11.1.1.7
(2)
OBIEE 11g
(132) OBIEE Errors
(3)
OBIEE Installation
(4) Object Level Security(2) OC4J (2) ODI
(2) ODI Repository
(1)
OLAP (9) OLTP
(3) Oracle
(85) Oracle 10g
(29)
Oracle 11g
(29)
ORACLE APPS
(4)
Oracle BI Admin Tool (2) Oracle BI Answers(2) ORACLE BI APPS
(4)
Oracle BI Briefing Books (1) Oracle BI Cluster Controller (1) Oracle BI Delivers (2) Oracle BI Disconnected Analytics (1) Oracle BI Interactive Dashboards (2) Oracle BI Java Host (1) Oracle BI Office Plug-In (2) Oracle BI Presentation Server (1) Oracle BI Publisher (2) Oracle BI Scheduler (2) Oracle BI Server (6) Oracle Collections(1) ORACLE PLSQL
(2)
Palerra (1)
Parameters
(1) Parent-Child Hierarchy(2) Partition
(1)
Pass-through
(2)
Physical layer
(1)
Pig (3) Pivot
tables
(1) PLSQL (18)
Power Centre
(4)
Power Mart
(1)
Presentation layer
(1) Presentation Variable(1) Privileges
(1) R
(1) Ragged hierarchy(3)
RDBMS (3) READ
ONLY TABLES
(1) Reddit.
(1) Redis (2)
reject file
(1)
Reporting
(2) Repository
(10)
Repository Modes
(2)
Repository services
(1) Repository Variables (1) Request Variables (1) Reusable Transformation(1) Riak (1) Role
(1) Round-robin
(2) Router
Transformation
(1) SAP (1) SAP
HANA (1)
SAS (8) Scala
(1) Scala
Programming Language(1) SCD (4)
Sequence Generator
(1) serialization
(1)
Session Variables
(2) Sessions
(6) Skip-level hierarchy (2) Slowly Changing Dimensions (4) Snowflake Schema(1)
Sorted Input
(1)
Sorter (2)
Source Qualifier
(3)
Spark (3) Splice
Machine
(1)
Splunk (1) SQL
(52) SSIS
(1) Staging Area
(1)
Star Schema
(1)
Static cache
(1)
Statistical Analysis(1) Subquery
(2) Sun's Solaris
(1)
Surrogate key
(2)
Suse Enterprise Linux(1) TensorFlow
(1)
Teradata (2)
Thomas Kurian
(1)
Top N Analysis
(1) Transaction Control transformation(1) Transformation
(2)
Triggers (1)
Twitter (1)
Ubuntu Linux
(1)
Unbalanced hierarchy (3) Unconnected Lookup(1) Unix (6)
update strategy Transformation(1) Varrays
(1) Virtual Column
(1)
VoltDB (1) Web
Server
(2) WebLogic Server
(1)
Workflow Manager
(3)
Zookeeper
(1)
DWHLAUREATE
COUNTER
Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0