SAP Network: Re: differences **** DO NOT REPLY TO THIS ADDRESS ****

SAP Developer Network Forum post forwarded by: amol shah
Please reply using this email address: amol_shah@colpal.com

- - - - - - - - - - - - - - - - - - - - - -

Forum post in BI General: Re: differences
https://forums.sdn.sap.com/thread.jspa?threadID=386786&messageID=3348229#3348229

Dear Friend,

Flexi Update : used for transactional and master data
(except hierarchy).
Direct Update : only for Master data

Differences:
------------

Flexi Update. / Direct Update.

1. Manual Infosource creation / InfoObject itself
treats IS.

2. Update Rules are required / No Update rules.

3. BEx Reporting available / No BEx reporting.

4. Data Tragets required / Infoobjects itself
Data Targets.

Regards,
KS

- - - - - - - - - - - - - - - - - - - - - -

Visit the SAP Developer Network at https://www.sdn.sap.com.

SAP Network: Re: What is the difference between ETTL and ETL **** DO NOT REPLY TO THIS ADDRESS ****

SAP Developer Network Forum post forwarded by: amol shah
Please reply using this email address: amol_shah@colpal.com

- - - - - - - - - - - - - - - - - - - - - -

Forum post in BI General: Re: What is the difference between ETTL and ETL
https://forums.sdn.sap.com/thread.jspa?threadID=366021&messageID=3253858#3253858

hi

for ETL
ETL: Extracting , transforming and loading is the process of reading (extracting) from heterogeneous sources and transform them so that discrete data from different sources gets integrated and then loading into the data warehouse.
Extracting: Reading and understanding the source data and copying the parts that are needed to the data staging area for further work.
Transforming: Data transformations are often the most complex and, in terms of processing time, the most costly part of the ETL process.
Loading: Discrete data from different sources gets integrated and then loading into the data warehouse

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/2059
https://www.sdn.sap.com/irj/sdn/thread?threadID=356107

For ETTL
Besides the difference in designing the database, building a data warehouse involves a critical task that does not arise in building an OLTP system: to extract, transfer, transform, and load (ETTL) data from diverse data sources into the data

In data extraction, we move data out of source systems, such as an SAP R/3 system. The challenge during this step is to identify the right data. A good knowledge of the source systems is absolutely necessary to accomplish this task.

In data transfer, we move a large amount of data regularly from different source systems to the data warehouse. Here the challenges are to plan a realistic schedule and to have reliable and fast networks.

In data transformation, we format data so that it can be represented consistently in the data warehouse. For example, we might need to convert an entity with multiple names (such as AT&T, ATT, or Bell) into an entity with a single name (such as AT&T). The original data might reside in different databases using different data types, or in different file formats in different file systems. Some are case sensitive; others may be case insensitive.

In data loading, we load data into the fact tables correctly and quickly. The challenge at this step is to develop a robust error-handling procedure.

- - - - - - - - - - - - - - - - - - - - - -

Visit the SAP Developer Network at https://www.sdn.sap.com.

training over

So finally the training is over.
Those who don't know, let me tell u guys.
I got a job on SAP.
The training was good.
The system is too vast.
Something i have understood in the training.
From Monday I'll be probably on a live project.
I have been assigned Production support.
So I'll sharing all the issues right out here.

training tobe or not tobe

the most boring part of joining a company.

as specially if the the trainer has a accented english. :))

 

welcome again

Hello world.
Finally i got time to post to this blog of mine.
Its being a hell lot of work this days, but hopefully everything is scheduled so that i can post regularly.

ok then.
enjoy!!!

the social networking war.

hmmm what should i start with now. The thing is, there is something going on in my mind this days. There is THIS type of sites which help us to stay in touch with each others. I mean friends and relatives. And i swear it really helps. I really met some of my old friends, thnx to a web site which provides this kind of facility. Now this type of sites are called Social Networking WebSites. I am here not to favor any of them, but its a discussion of whats going in the web market.

Well i will not name the any of the Sites, but let me name the biggies who are behind this projects. Currently i am only focusing on the BIG THREE as i term them "Microsoft, Yahoo and Google".

OK so it all started with the BLOG war. Google acquired Blogger.com. Yahoo started yahoo 360. Microsoft started spaces.microsoft.com. Well yahoo 360 is not a core blog concept, but currently lets assume it as a blog site. This is because yahoo doesn't have a site dedicated to WEB LOGGING(Blog) .

Oh Gosh!!!, let me be back on the topic, otherwise i will reach on to some other discussion. So after blogging came this image posting sites. Here yahoo was first to buy out Flickr, which is currently the best in this market. Of course there was images.yahoo.com, but nobody bothered to look at it. Fortunately Microsoft and Google doesnt need this kind of site, since their blogging counterpart already supports image posting.

All this and many other sites were acquired, to reach to a final goal of what I think is THE SOCIAL NETWORKING SITES. Google was affiliated with Orkut. Yahoo acquired Del.icuo.us and there were also some contenders who probably pioneered this concept. Likewise we have Upcoming.org, Ringo, Birthday alarm, HI5 etc. Somehow these sites doesn't clicked. They were bulky, very very slow in operation. But the concept was awesome.

Beware, we are now at the start of the war between the BIG THREE on this concept. Orkut is currently leading the three. Orkut is the best of these. Though it was not a child of those Googlers, but the way it was made, is perfect to get affiliated with google. It has those characteristics of Google: Simplicity, Fantastic Interface and Navigational Facility that made it work. Also the site is very quick. Kudos to ORKUT, the guy who created this genius. But one thing you people can relate him is, he is also from Stanford, Gotch ya!!!. These Stanford people are going to rule the world in near future, hahaha!!!. Now is YAHOO's turn. It has integrated all of its acquisitions and sites to yahoo 360. Also the blog in yahoo 360 can be directly integrated to your geocities account. So all thing comes to a single point Yahoo 360. Now this have many features of a social networking site other then just blogging.Very nicely organized, of course its yahoo, the ppl who pioneered the INTERNET.

Hence comes the turn of the GIANT. Yes you people guessed it right. THE NAME IS "microsoft". How can it be left behind. Microsoft has way behind started a site named WALLOP.com. It was just a simple blogging site, but with some unique features of connecting with friends. This site was one of the best because it was totally on MACROMEDIA FLASH. The interface was mind blowing. But now after a long time when i went to this site, there was nothing. Only there is massage for the people, that they are getting ready for the war. JUST visit the website its FANTASTIC. Now only GOD can predict how will Microsoft will turn this whole concept into. WAIT and WATCH.

Above article is just my flow of thoughts on the topic. Its not supporting any side. The article its just my perception and assumptions. So some of the facts may be wrong or incomplete.

If you people have read this whole article completely, thank you very much for taking time to read it.Well the thank should be more for bearing my mistakes if any.
I will be very obliged to improve on your positive comments/suggestion. just fell Free to comment on any aspect, since this my first article of any type and of such a length. THANKS A LOT in advance.

the rickshawwala story

Ok guys i finally got time to complete this story.

There is nothing so special about this whole rickshawwala thing. I just thought to cover this story to highlight some of our day-to-day conversations with the rickshawwala. What all problems they have to face, and what all different circumstances they have to undergo. I am narrating one conversation which i feel needs attention.

Scene : I was going to Place X, as i was getting late i decided to catch a rickshaw. It was around 8:00 pm, I asked a richshawwala for the place X and he was ready to go. So now we were moving on the way, and suddenly i saw a tremendous long queue of this rickshawwala. I was shocked by the queue as it was very very long. Then as we moved further i noticed it was for a CNG gas filling station. I dont know how, but i just said to the driver "yeah itna bada line to pehli baar dekha hai maine". Unfortunately his rickshaw was CNG too and then the story started. I will name the rickshawwala Mr. Chandu

Chandu told me that this is not the 1st time, everytime they have to stand in such long tedious queues to fill gas. Now for those of them who do not know CNG works in same way for CNG rickshaw as petrol works for petrol rickshaw. Chandu told me in anger that as the filling station were very limited there is no option but to stand in this queues to source gas.

Now comes the worst part. As they cannot afford to stand in this queues during day time, as this duration is for their earning, they opt to get in the queue during night hours. Incidentally chandu was out of gas and I was his last passenger for the day. Chandu told in disgust that, now he will directly go home, have his dinner and then come back to the filling station to stand in the queue. You people will not believe of what he told next.

Chandu told me that it will take him the whole night in queue and probably his turn will come at say 7 O' clock in the morning. So i asked him excitedly, how will he complete is sleep during this event :)). He told that there is no way that he can complete his sleep. Because every five minutes he have to move his rickshaw forward in the queue. So by this time he can sleep in the rickshaw for a 5-5 minutes slot. And again when the day starts he has to run for his ROZI ROTI

He was very angry as in, from the time the municipality has compelled this people to convert rickshaws to CNG, their sleep is ruined. So the life of these people is not as simple as it looks from outside.

You people might have gone through such situation, feel free to share and comment on this article.