I am very sure, that they asked me like that. Because , I asked them twice to make sure that I heard what exactly they asked.
I told them the answer of What we do with OLEDB. And you know, a month ago, there was another interview, and this guy asked me diff b/w OLEDB and OLTP.
I know that there are no differences, and they are totally different like you said but I was very confused since I was asked these questions in two interviews.
Since then I started to think, "is there really any relation b/w OLEDB with OLAP and OLEDB and OLTP.....?? "
So that's why I just came here so that you gurus will clarify me....
OLAP and OLTP are architectural designs of a database. The first is optimized for analytical queries, the second one for doing as much transactions as fast as possible. Hence their names...
OLEDB is a type of provider used to connect to databases. It is something completely different. But it is possible that an ETL system that loads data into database (be it OLAP or OLTP) uses OLE DB connections.
The answer to the transaction question is: it depends. The required one will roll back, the second one might roll back if its parent container has a transaction setting to Required. If not, it will not roll back.
"If both of them rolled back, then what is the difference between setting options to required and supported? "
--> depends on the settings of the parent container
How to post forum questions.Need an answer? No, you need a question.What’s the deal with Excel & SSIS?
My blog at SQLKover
MCSE Business Intelligence - Microsoft Data Platform MVP