In: Business and Management

Submitted By bunky
Words 1990
Pages 8
Recap of the BIW – ETL Process The most important part of any Business Information Warehouse (BIW) or Data Warehousing is a process of extraction, transformation and loading of the data from different source systems that are able to provide data which are relevant to a business organization. This data is mainly from its core applications that are used by the business units to execute the enterprise business processes across them. The ETL is also a Strategy about how data from different known source systems can be extracted, transformed and loaded into the BIW or data-warehouse system which then can be used for designing queries, reports and dashboards to enable the business to make decision at different level of the organization (Top Level, Middle Level and Operational Level). (a) extracting data from outside sources, (b) transforming it to fit business needs, and ultimately (c) loading it into the data warehouse Enterprise Data Warehouse (EDW) is mega data mart where all the data from various source systems get consolidated and let the other data marts within other systems use it by pushing the relevant into these data marts through ETL process. So EDW can be a data provider (like any other source system) to various data marts, decision support system applications, data-mining or exploration warehouse applications ETL Concept:

Components: (a) (b) (c) (d) Source Systems Data Source (PSA – Persistent Staging Area) Transformation Loading

Source Systems can be one or more of these which can become the initiation of the data for the SAP BIW (a) SAP Source – SAP ERP, CRM, SRM, PLM (b) Relational Source – Relational Databases: MS-SQL, ORACLE, DB2, INFORMIX, SYBASE (c) Multi-dimensional Source – These are especially other business information warehouse (BIW) systems or BI systems such as Hyperion by Oracle based on ESSBASE, OBIEE by Oracle COGNOS by IBM, (d) Legacy…...

Similar Documents

West Bengal

...In more recent period, resistance to industries with various excuses has been witnessed. This is understandable because the policies pursued by the Left Front government have earned the confidence of the investors and an ambience of rapid industrial development has been created in the state. The chambers of commerce and industries, big industrial houses, foreign and domestic investors and even the die-hard critics of the Left have been appreciating the role of the state government and its policy framework.  It needs to be mentioned that the process of industrial development of West Bengal has its own history. From the colonial days to the period prior to the country’s independence, the state occupied a pre-eminent position in the manufacturing, iron & steel, textile, jute, tea and other sectors. Its growth in the cottage & small scale sector was equally impressive in first decades in the post independence period. However, the development process had to face many problems in the years that followed for a variety of reasons. Among them the policies of the successive central governments like freight equalisation and manifest bias through licensing system were crucial. These, along with lack of policies of the then Congress government in the state, led to the sluggish industrial growth. The socio-political unrest from the 60s also negatively impacted on the investment climate of the state as well as engineered the flight of capital to other regions. The negative perception...

Words: 3543 - Pages: 15

Expansion West

...Expansion west The expansion of the American west from the Atlantic Ocean to the Pacific Ocean has affected the United States in many ways, settlers held the belief that they were meant to expand through the continent. Westward expansion meant that there would be political unrest for many reasons. In moving west, settlers had trouble with Native Americans. Settlers tried to have them removed by the government but not everyone was in agreement on how to do this. Some wanted to use force, others wanted to deal peacefully with Native Americans but this did not happen fast enough for some settlers. In order to remove Native Americans many crimes and atrocities were committed against them, many tribes were forced to leave their land or be killed. This resulted in hostility from Native Americans toward settlers, which in turn wanted the government to defend them against the “savages”. These problems were the reasons that Americans had such a bad understanding of who Native Americans really were as people. Slavery was also a big political and social issue in the west ward expansion, many people opposed slavery and wanted it to be abolished; others such as land owners and cash crop exporters wanted slaves to be seen as property and nothing more, so that they could continue to exploit them for free labor. Plantation owners wanted to expand their holdings and the amount of crops that they could export. For land owners, going west had great possibilities. As The United States...

Words: 612 - Pages: 3

Reconstruction and the West

...Reconstruction and the West Anthony Webb College of Humanities His/120 Version 5 U.S. History 1865 to 1945 Resolution/Sociology 110 February 16, 2013 Elizabeth Jewell Reconstruction of the South According to Eric Foner (2008), “even though Reconstruction failed to meet the goals of Radical Republicans, painlessly rebuild the South, and give the freed blacks complete rights, Reconstruction did give African Americans some new chances and a brief taste of a free society ("Was Reconstruction a," 2008). Public schools were instituted; blacks became citizens, and some whites even offered support with the civil rights movement. However, every opportunity that was given to the free blacks was met with much opposition. As a result, more could have been done. The late 19th century was a troubling time, and although freed slaves were negatively impacted, Whites, and Indians were also affected by the economical hardships. Several events occurred which gave me cause to agree with Eric Foner’s description of the Reconstruction as a “splendid failure”. Blacks did not receive all their rights until 100 years after the war. Furthermore, Northern-born white men who moved south after the Confederacy defeat were called carpetbaggers by Southerners, and Southern-born white Republicans were given the name scalawag; Blacks held fewer governmental positions and was smaller than their proportion in the population; Indians suffered from the white Americans’ racism...

Words: 878 - Pages: 4

American West

...resulted in many Mormons choosing to move West in the face of increasing violence. The increasing population had made land hard to come by. This combined with the desperation and increasing crime in the East forced people to consider moving West. The Crisis became a big PUSH factor in encouraging people to migrate westward. 1844 Joseph Smith Died As the Prophet and founder of the Mormon Church he was the leader of many thousands of believers. He led them in a desperate search for a safe haven for the community to settle. Smith would not lead his Mormons West as he thought it unfit to build the Zion for the coming of Jesus. Smith was shot dead in 1844 as he tried to escape from jail. Brigham Young was the new leader of the Mormons and chose to lead them West, to Great Salt Lake where they settled successfully. This was an important turning point for the Mormons. 1848 Gold Rush 1848!! Before Gold was discovered in 1848 by James Marshall, around 5,000 people per year were drifting west across the Great Plains. However with the discovery this increased tenfold by the following year.The 50,000 miners were hunting for their fortunes in California –many found one. The first miners – the ‘49ers – proved that large numbers of settlers could travel and live in the west. The paths and routes they used were easily found by later families who travelled west. By 1850 California was a US state. The 1848 Goldrush speeded up the settling of the west by Americans. 1851 First......

Words: 1164 - Pages: 5

Economies of the West

...imperialism, Spain struggled. Interestingly enough, Spain was one of the first Western countries to obtain colonies in the West Indies. However, by the 19th century, Spain lost their colonies due to rebellion from the inhabitants seeking independence. Territories such as Bolivia, Ecuador, Venezuela, and Argentina successfully rebelled from the Spanish occupiers. Mexico, Chile, Paraguay, and Uruguay followed suit. (3) Spain also lost their colonies in the West Indies. The West Indies represented a huge portion of Spain’s economy. Agriculture was quite important in solidifying economic position in the Caribbean. The trading of sugar, molasses, coffee, rum, and tobacco was quite profitable to Spain and other Western countries involved in colonization. Another major source of commerce was the slave trade otherwise known as the Triangle Trade. Once news travelled of successful rebellions against the Spaniard occupiers, many West Indian territories fought for their independence as well. Not only was Spain fighting rebels they were also fighting other Western nations for territory. They had already lost Jamaica to Britain in 1655. They eventually gave Trinidad to Britain in 1802 only to lose Santo Domingo on the island of Hispaniola in 1821. By the time the smoke cleared, Spain had lost all their possessions in south and central America, the Americas, and the West Indies. All that was left was Cuba and Puerto Rico. Once the slave trade simmered, Cuba relied on exports to America.......

Words: 765 - Pages: 4

Triumph of the West

...western civilization. In the later years to come China made a vast decision to become a communist country. China becoming a communist country would create an internally stable economy system, help build a stronger social community, and help set equal opportunities for everyone. All these things would help China grow and become a greater country. Another idea that was influenced by the western was consumer goods, by china adapting to this it create a stronger and much sturdier economy and would also raise the expectations of the public. By raising the expectations of the public, people would strive for better and greater products. Lastly China adapted the English language from the west. English is known to be the second language worldwide, by learning English you would be able to communicate with people of the west and also it would improve job opportunities and improve education....

Words: 520 - Pages: 3

The West

...The West Tommeca Boyd HIS/125 August 31, 2014 Kristopher Daniels The West How did the culture of the Plains Indians, specifically the Lakota Sioux, change in the late 19th century? Since the migration to reservation camps, things have changed a lot in the Lakota Sioux culture. Before the migration the Sioux were used to living off of the land, making clothing out of hides of leather and hunting for their own food. Now half of the Sioux live on reservations in South Dakota, North Dakota, Nebraska, and some in the northern part of Montana. Most of them have a hard time just trying to survive because the way they use to live was the only thing they knew and they didn’t know any other ways of getting food other than hunting. The Sioux tribe was torn apart because of their land being stripped from them by white settlers. The government, particularly President Grant, purposed and passed many treaties of peace, but wasn’t able to properly enforce them causing American military personnel and citizens to become openly hostile. These peace policies’ required Plains Indians to live in small reservations, receive a ration of food and supplies from the U.S. government, and adapt American ideals. The small reservations were built on land with soil that could not be harvested and were constantly being invaded by the surrounding white population, and corruption within the U.S. government allowed many White settlers to eventually take over reservation land, further......

Words: 907 - Pages: 4

The Decline of the West

...The Decline of The West Short story by: Hanif Kureishi The Decline of the West is a short story written by the English, half Pakistani writer Hanif Kureishi in 2010. The main theme in the short story is the capitalism and how material we have become in the West in the year of 2010 and how we strive to gain material comfort ahead of true happiness and greater meaning in life. The short story’s main character is a forty-five year old man named Mike who is on his way home to his family. It takes place in the upper class of the outskirts of London. Mike thinks that his family will appreciate that he is home early from work, which is not something that occurs since he is not working less than twelve-hour shifts. Mike seems as a hard-working man who does not spend much time with his family and we get a very negative picture of his family. There is a very cold attachment between him and he family since he is never home. But they can be demanding and the content that fills up their lives is material goods. At the short beginning the atmosphere and language is described very positive. Mike has endured the most desolate tube trip home and is looking forward to come home to his family and their home which is described as a nice and warm home he is looking forward to come home to; “Opening the door to a warm hall hearing the voices of his wife and children”. Though he has to tell his wife, Imogen that he got fired from his job. The language is well written in informal......

Words: 1090 - Pages: 5

Rise of the West

...Critical Analysis: Rise of the West There are many theories and ideas of how western civilization became the way it is today. While some scholars believe it is in one influence of another region, many others can argue that it is certainly just the way the world is supposed to work out. We, as humans, have no control over how our surrounding civilization will turn out nor would we be able to alter many thing that have happened in the past. Robert Marks provides his own examples and theories to prove that other regions such as India and China have a significant part in the outcome of the west. The ideas of Eurocentrism, contingency, accident theories and conjuncture are all theories that are mentioned throughout the narrative to allow readers to understand the point of view the author is coming from. The narrative points out examples and ideas of many scholars who have their own opinions of the rise of the west and the many influences that surround it. Not only does the author of the narrative explain his own views and opinions, but he uses evidence from scholars such as Karl Marx and Freidrich Engels to support his claim as well. "The Rise of the west" is a narrative that provides many examples of how the west was influenced by many other regions and not solely just on European culture. In the narrative, Marks seeks to expand his ideas on how he believes that the world's western civilization was created and influenced by other cultures rather than just one region, Europe....

Words: 1324 - Pages: 6

Reconstruction and the West

...Reconstruction and the West HIS/120 Reconstruction * The post-Civil War South has been called the “New South.” In what ways did it succeed in reinventing itself? In what ways did it fail? After the war ended as many as four million slaves were freed. The south had freed slaves and now had a war torn area that needed rebuilding and restructuring. For the next few decades the focus was on creating a railroad expansion and fixing the farm lands. New textile, iron, and steel industries came to be with great success. Farming was a big part of the south and many freed slaves continued to contribute on farm lands for meager wages. The issue with the reconstruction was the newness of the world around everyone. Many white southern slave owners continued with their unfair and brutal treatment of former slaves. With no one around really setting down the new laws many people just did as they pleased. Many people, white and black became homeless and starved to death because there was no system in place to help. Abraham Lincoln was on the right path to fixing the issues the south had after the war. However after his assassination, Johnson took over and pretty much ignored all of Lincolns plans. This was the unraveling of the original reconstruction plan. Johnson had no concern for the freed slaves and their circumstances. This was the unsuccessful part of the reconstruction that seemed to majorly overshadow the small successes. Though the majority of plans for helping the......

Words: 679 - Pages: 3

The West

...Farhang Hesami Document 17-1 A. Summary This article includes an appeal written by a Chinese merchant named Pun Chi to Congress asking help against the anti-Chinese sentiments which was growing, especially in the West. In the first part of the appeal Chi talks about how American ship-masters went to China and encouraged people to immigrate to California during the Gold Rush. He mentions that those Americans would tell them about the beauty of Americans kind and friendly manners. But, when they came to the West they faced a complete different situation. He complains about the brutal violence against their race and that they would not have the basic human rights with no guilt. Pun Chi has addressed 6 major issues in this appeal, which we can read 4 of them in this article. In first part, he talks about the virtue and morality. That people of China would value the virtue a lot and it is not right to be evil to them. He believes Chinese are very kind heart people and it is not important if they are poor. Wealth with no morality is worth nothing. He also mentions Jesus Christ and the importance of virtue in Christianity. In the next parts of the appeal he writes about pf the perpetual vexations of the Chinese. He asks that why his people should be the target of verbal and physical violence. He also questions the justice system. In that time Chinese would not have the right to have testimony at courts and Chi sees that as a reason for whites giving themselves the right......

Words: 674 - Pages: 3

The West Bank

...felt that Dr. Hisham was sexist for taking so long to give Nura her vaccines due to her being a female dog. She was able to get better medicine for Nura. This is a big deal because Nura enjoys more political rights than her owner. Suad's West Bank I.D. does not allow her to travel from Ramallah to Jerusalem, although Nura can. Suad paints the picture of the irony that an animal can get a passport quickly, whereas, it can take the Palestinian people years to obtain one. 2. With the occupation of Ramallah under Israel, the curfew made day to day living challenging to say the least. During curfew the Palestinian people lived on lock down in their homes. This was a challenge because there were entire families living in small confined spaces. When curfew would lift the streets would become so crowded and the grocery stores would become chaotic. Suad seemed to find humor with the invasion, however, Um Salim, seemed to be more of a challenge for her. Um Salim would get confused and fret over small things. Um Salim would go on countless stories that Suad was tired of hearing. Um Salim worried over her possession, no matter how inconsequential they seemed to be. 2.1 The Six Day War in 1967 designated the Gaza Strip and territories along the West Bank as occupied territories. It is my understanding that Israel felt like the the territories were not allowing them to exist in peace. And the Israeli's felt like the territories were their land to begin with. The fighting seemed to......

Words: 1153 - Pages: 5

The West

...Catherine Jones HST-143-D040/Professor Quirk The West January 21, 2016 Moving and settling on the Great Plains during the nineteenth century was no easy task. There were many hardships involved in the laborious task of the moving process and even more involved in building and maintaining a home. The fact that the settlers were moving to the Great Plains added even more difficulties to the task because of its climate and geography. One of the hardships that settlers faces was that there were few building materials on the Great Plains. They usually constructed their houses out of sod which was less than ideal. Sod houses allowed bugs and animals to easily dig through the walls and it also leaked water into the homes very easily. These sod homes also allowed very little light or even air to pass into them. Other hardships included their isolation from one another, the unfortunate use of manure as fuel for fire because of the lack of wood, the dry climate of the Great Plains, and as a result of the climate, the lack of water. Settlers could not plant crops because the ground was too dry and the climate was too humid, that and the fact that there was the lack of water. This forced the settlers to build windmills just so they could pump water. There was also the obstacle of having a lack of money. Since the settlers were so isolated from one another that meant there were no nearby businesses or places of work for settlers to earn money. This lack of money meant living in......

Words: 326 - Pages: 2

The West

...Why the West Rules for Now Part Three Written by Ian Morris In this part, the author focuses more on the future and social development. It starts out by explaining that biology is not the answer to why the west rules for now, it is social development. The key to social development is that the west had the more favorable geography. This gave the west several generations ahead of the east, but the imbalance of progress was able to give the east more time to catch up with the west in terms of development. Because of the ability to farm, and because people are more of the same, westerners had an advantage. The point is that geography made it easier for westerners to advance in social development. After Morris explains a brief look in the past he then focuses on our time and the future we have ahead if trends continue to occur. And according to all the information we know now, the East will catch up to the West in about 2103. But, only if western society stays the same as it is. Morris chooses this estimate because of past trends. He uses an elaborate scoring system that gives a rough estimate to show the amount of change now as opposed to the past. And he concludes that change has occurred 4 times faster now than social development in the past. The world is changing very dramatically and he calls the 21st century of period of time called the singularity. The singularity is the theory that innovations are occurring so fast that it appears to be instant and that...

Words: 974 - Pages: 4

Mother of the West

...Taylor Pittman Professor HubbardLiba 102 sec. 497 December 2008 Mother of The West It goes without saying, that the Western film genre is a male dominated society. Often times the importance of female roles are shoved to the side for that of a mere sex symbol. In 1968’s Once Upon a Time in the West, director Sergio Leone opted to forgo that route and instead cast the iconic beauty Claudia Cardinale as the resilient Jill McBain. Through her steadfastness in times of immense adversity and creative symbolism, Leone develops Jill McBain as a mother to the new West. Director Sergio Leone wished to capture the audience the moment Jill is introduced in the film. As the camera pans over the train which carries Jill, jubilant background music can be heard. The score in this scene is a complete contrast to the sinister sounds which filled the opening scenes of bloodshed. Knowing the diligent attention Leone gave to sound, this song can be perceived as Jill’s theme, much in the same way as Harmonica. Jill is first shown smiling and looking over the train-yard and then gracefully helping herself down the steps. This one shot establishes Jill as a person who is eager to live somewhere new, boldly stepping down into the dust filled West while maintaining her pleasant disposition. As Jill begins to walk through the crowd she pays special attention to numerous types of people. Leone chose to include blacks, Native Americans, Union soldiers and young and old of all type of people in this...

Words: 1052 - Pages: 5