Project REAL Reference Implementation

The Project REAL reference implementation provides you with a working sample to build, implement and test the solution in your organization. The sample schemas, code, and architecture can be used to jumpstart the development of your own Business Intelligence solution. It contains a subset of the Project REAL data so you can see how various parts of the system work with actual data. 

The kit contains:
1. A set of instructions for setting up the environment
2. Guidance on how to explore the implementation
3. A sample relational data warehouse database (a subset of the Project REAL data warehouse)
4. A sample source database (from which we pull incremental updates)
5. SSIS packages that implement the ETL operations
6. An SSAS cube definition and scripts for processing the cube from the sample warehouse
7. Sample SSRS reports
8. Sample data mining models for predicting out-of-stock conditions in stores
9. Sample client views in briefing books for the Proclarity and Panorama BI front-end tools

Project REAL Reference Implementation

XML File - Bulk Insert - Fixed Length Flat File

Hi All,
During the last few days i was trying to figure it out how to generate XML file for a sql table and load data from a text flat file by using BULK Insert statement. By following the below example we can load data fixed length flat file into SQL table.
1.To generate XML by using BCP command
bcp DBName.Schema.Table format nul -c -x -f "D:\FileName.xml" -T -S
2. Modify the generated XML file inorder to handle for fixed length columns:

Note: Either format the XML file as in screen1 or in screen2.It works for both ways.
3. Use BulkInsert statement inorder to extract data based on fixed length text flat file:
Bulk Insert [DBName].[Schema].[Table]
FROM '\\ServerName\Pathfolder\FileName.txt'
WITH (FORMATFILE = '\\\ServerName\Pathfolder\FileName.xml')

Again started blogging

Hi All,

After a long time i started to share my thought again through the same web site.It's happy to share my thoughts again.Thank you for visiting.