Informatica Scenario:How to load every nth row from a Flat file/ relational DB to the target

How to load every nth row from a Flat file/ relational DB to the target? Suppose n=3, then in above condition the row numbered 3,6,9,12,....so on, This example takes every 3 row to target table.

1. Connect an expression transformation after source qualifier.Add the next value port of sequence generator to expression transformation.

    2.  In expression create a new port (validate) and write the expression like in the picture below.

3. Connect a filter transformation to expression and write the condition in property like in the picture below.

    4.Finally connect to target.

Informatica scenario:How to get top 5 records to target without using rank

Solution:

1.     Drag the source to mapping and connect it to sorter transformation.

2.     Arrange the salary in descending order in sorter as follows and send the record to expression.

3.     Add the next value of sequence generator to expression.(start the value from 1 in sequence generator.

4.     Connect the expression transformation to a filter or router. In the property set the condition as follows-

5.     Finally connect to the target.

Business Intelligence (BI)

What is Business Intelligence (BI)?

•  Business Intelligence is a generalized term applied to a broad category of applications and technologies for gathering, storing, analyzing and providing access to data to help enterprise users make better business decisions
• Business Intelligence applications include the activities of decision support systems, query and reporting, online analytical processing (OLAP), statistical analysis, forecasting, and data mining
• An alternative way of describing BI is: the technology required to turn raw data into information to support decision-making within corporations and business processes

BusinessIntelligence Architecture

Business intelligence has become a critical element of information technology. It’s an old term with general or even ambiguous meaning. It has been used synonymously with decision support, analysis, and data warehousing, but today business intelligence has a more specific definition and a better understood application. Taken literally, business intelligence is just that—intelligence or understanding of your business. You get that understanding by analyzing your business operations.

This business intelligence process can deliver significant, bottom-line results. Implementing its technologies and applying its process can help make your business more effective and more efficient, increasing revenue, decreasing costs, and improving your relationships with customers and suppliers.

   Why BI?

• BI technologies help bring decision-makers the data in a form they can quickly digest and apply to their decision making.
• BI turns data into information for managers and executives and in general, people making decisions in a company.
• Companies want to use technology tactically to make their operations more effective and more efficient - Business intelligence can be the catalyst for that efficiency and effectiveness.

By definition, the moment any given business is operating, it begins generating data. Some obvious examples are sales, bookkeeping, production data, warehouse information, transportation and logistics, personnel, etc.In addition there also exists large volumes of data which are important to the business but not directly generated by business operations. Examples are market data, competitive data, tenders and proposal, legal information, raw material prices, etc.

As such, none of the above described information can be used in its raw form by corporate management to make decisions although the information is critical in helping make those business decisions.Therein lies the necessity for Business Intelligence. BI technologies help bring decision-makers the data in a form they can quickly digest and apply to their decision making. BI turns data into information for managers and executives and in general, people making decisions in a company.

     Benefits:

 The benefits of a well-planned BI implementation are going to be closely tied to the business objectives driving the project.

1. Identify trends and anomalies in business operations more quickly, allowing for more accurate and timelier decisions.
2. Deliver actionable insight and information to the right place with less effort .
3. Identify and operate based on a single version of the truth, allowing all analysis to be completed on a core foundation with confidence.

 

Facebook Commentbox