Difference: Back end and Front End

[Former Member]

I normally get this question: You’ve worked on BW before, right? Backend or Front end? Any clear definitions for what “Backend” and “Front end” is about?

Also. I went to this project room and found out that those on the left side were the BW group and those on the right side were the ETL group, working on Informatica. I used to think those doing the extraction were the “Backend” while “the BW stuff were the front end. But here, one guys say, “we do the backend they are the BW guys ….

I will appreciate some clarification.

[Former Member · Accepted solution]

Amanda

It's a good question

Backend: Data Modeling and Design. Requirement gathering building info objects like Info Cubes, ODS Objects, Multi providers etc.

ETL: Responsibilities to extract Data from different Source system and load into BW while doing this they do all kind of mappings between source system and BW.

Front end: This is responsible to build reported based on ODS Objects and Cubes built by Backend team

Hope this helps. Please feel free to ask questions

thnaks

Sat