This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

DWH

/Tag:DWH

SAS Interview Questions and Answers – Part 5

By | December 13th, 2013|DWH, SAS|

71). Describe the ways in which you can create macro variables? There are the 5 ways to create macro variables: %Let %Global Call Symput Proc SQl Parameters. 72). Tell me more about the parameters in macro? Parameters are macro variables whose value you set when you invoke a macro. To add the parameters to a [...]

IBM Cognos architecture overview

By | May 9th, 2013|Cognos, DWH|

1). Cognos 8BI architecture can be separated into three tiers: Web server  Applications Data 2). The tiers are based on business function, and are typically separated by firewalls 3). User interfaces sit above the tiers 4). Zero-footprint user interface that uses the default browser configurations provided by Netscape and Microsoft  

Cognos 8 – Introduction

By | May 6th, 2013|Cognos, DWH|

Introduction Cognos 8 Business Intelligence is an integrated enterprise solution Cognos 8 combines major upgrades from ReportNet, PowerPlay Web Explorer, Metrics Manager, and DecisionStream, and further integrates these components. It includes new versions of Report Studio, Query Studio, and Cognos Connection New features PowerPlay Web is replaced by Analysis Studio Metrics Manager is replaced by [...]

Parallelism and Partitioning in Data Warehouses

By | March 12th, 2013|DWH, Informatica|

Difference between Partition Parallelism and Database Partitioning Database partitioning applies to DB2 multi-node targets. When this type of partitioning is selected, the PowerCenter Server queries the DB2 system and loads partitioned data into the corresponding nodes.  How do you determine the optimal degree of partitioning/parallelism based on your hardware? Consider the mapping that will be [...]

Optimization Lookup Transformation Tips

By | March 12th, 2013|DWH, Informatica|

Lookup Transformation Optimizing Tips & Techniques  When your source is large, cache lookup table columns for those lookup tables of 500,000 rows or less. This typically improves performance by 10 to 20 percent. The rule of thumb is not to cache any table over 500,000 rows. This is only true if the standard row byte [...]

Informatica rename Repository Service

By | March 12th, 2013|DWH, Informatica|

Repository Rename Procedure on UNIX The following steps should be followed when renaming a copied repository from different environment. For example, when copying production repository to lab environment for testing purpose the repository name should be renamed and re-configured for lab environment. The following actions are to be executed with Power mart administrative privileges on [...]

How to Increase Informatica Server Performance

By | March 12th, 2013|DWH, Informatica|

Many factors can affect session performance.  Here are some points: Before doing tuning that is specific to Informatica: 1). Check hard disks on related machines. (Slow disk access on source and target databases, source and target file systems, as well as the Informatica Server and repository machines can slow session performance.) 2). Improve network speed. [...]

Advantages of Informatica

By | March 12th, 2013|DWH, Informatica|

Informatica can communicate with all major data sources (Mainframe/RDBMS/Flat Files/XML/VSM/SAP etc) It can move and transform data between all these data sources effectively. .It can move huge volumes of data in a very effective way, many a times better than even bespoke programs written for specific data movement only.  It can throttle the transactions (do [...]

Extraction, Transformation, and Load ( ETL) Issues and Approaches

By | March 12th, 2013|DWH, Informatica|

Introduction  This Article is created to understand the ETL architecture of tool and accordingly identify the errors occurred during job run and rectify the issue. It will help the person working in support environment to easily get the cause of issue. It is designed to understand the issues and correlate them with the different components [...]