SSIS Interview Questions


Comments

Post a Comment

Popular posts from this blog

WEBI Query Properties

Image
By using query properties, we can restrict the records to display in a report. Please check the options in query properties Max rows retrieved - Maximum number of rows of data that are displayed when a query is run. This is related with Sample Result set. For example, if you give 1000 rows in "Max rows retrieved" then 500 rows in "Sample Result Set" then you will get 500 rows only. Also it can be restricted based on the administrator security profile. Sample Result Set - It determine the Maximum number of queries returns. This restriction is applied in database level. Fixed - At each data refresh, query returns the same rows when Fixed option is marked. If not then on each data refresh, query returns different set of sampled rows Retrieve duplicate rows - In some cases, in database, the same data may be repeated over many rows. You can restrict those data using this option.
Read more

WEBI Report–Object from this query

Image
By default, "Object from this query" option will be disabled when drag and drop the object in query filter.     How to enable "Object from this query" option?   It is easy to enable this. As you can see in the filter, by default "In list" option will be there, by changing the value from list to other values , "Object from this query" option will be enabled. 
Read more

Access HANA view in SQL Console

Image
For each view, system will create a table whether it might be SAP HANA LIVE view or Calculation view or Attribute view. Those tables will be reside in system schema "_SYS_BIC" Expand the schema -> Column Views. There you can see lot of tables. Tables will be available for each view and each column inside that view. Make sure to get the main view. For example if you take HANA Live View "VBAK_COM". --Main View table select top 10 * from "_SYS_BIC"."sap.hba.ecc/VBAK_COM/" To select view with particular column, follow below select top 10 "SalesDocument" from "_SYS_BIC"."sap.hba.ecc/VBAK_COM" The above table can be access in SQL console, it will give the output which is same as what you have seen in the data preview. The other tables also available for columns select top 10 * from "_SYS_BIC"."sap.hba.ecc/VBAK_COM/SalesDocument/hier/SalesDocument" The above table will give deta...
Read more