ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Nov 11th, 2007

I feel that Dirty Dimension is nothing but Junk Dimensions. Core Dimensions are dedicated for a fact table or Datamart. Conformed Dimensions are used across fact tables or Datamarts. Sorry i never heard of Balanced Dimensions.Could some one explain what is Balanced Dimension?Regards,Ravi Kumar Garre

Answer Question  Select Best Answer

priya

• Jun 18th, 2013

Bteqexport is used if the number of rows is less than half a million. since it sends the data row by row.
fast export is used if the number of rows in more than half a million, it send data in 64kb blocks.so efficient in handling large amount of data

Answer Question  Select Best Answer

mahendra patnaik

• Feb 5th, 2007

If you want to run the graph through GDE then after save the graph just press F5 button of your keyboard, it will run automatically. if you want to run through the shell script then you have to fire t...

Answer Question  Select Best Answer

herbert

• Dec 9th, 2006

Drilling can be done in drill down,up ,through and across, scope is the overall view of the drill excersie

Answer Question  Select Best Answer

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Nov 11th, 2007

We can link one universe to other universe in Universe parameters.Regards,Ravi Kumar Garre

Answer Question  Select Best Answer

mithunmca

 Profile Answers by mithunmca Questions by mithunmca

• Mar 22nd, 2007

for a faster process create aggregate  tables and write better sql so that the process would fast

Answer Question  Select Best Answer

Hakoonamatata

 Profile Answers by Hakoonamatata Questions by Hakoonamatata

• Jul 9th, 2007

As the term suggests, a real-time datawarehouse is a system which reflects all changes to its sources in real time. As simple as it sounds, this is still an area of active research in the field. There...

Answer Question  Select Best Answer

Susheel Tamrakar

• Mar 28th, 2007

Method 1 is system develope lifecycle create by arthur anderson a while back.

Answer Question  Select Best Answer

satya

• Nov 16th, 2006

we can not use sql queries in filter transformation.It won't allow you to override default sql query like other transformations( Source Qualifier, lookup )

Answer Question  Select Best Answer

Sheraz Baig

• Nov 25th, 2013

Cube is basically the extension used with group by class to get the subtotals of the group. If "n" is the number of columns listed in the CUBE, there will be 2n subtotal combinations.
Syntex is :
GROUP BY CUBE ()

Answer Question  Select Best Answer

luckyDWH

• Oct 11th, 2007

The datawarehousing where all the operations activities maintained,?so?that?you?can?access?the?anaysed?data?from?adifferent?place.For example, take bank operations ... if A deposit 10,000/...

Answer Question  Select Best Answer

prudhvi.g

 Profile Answers by prudhvi.g Questions by prudhvi.g

• Sep 3rd, 2007

As per my knowledge in cognos, after creating a report just click beside the report to select whole report and then right click,click on properties and there you may found headers and footers,click on...

Answer Question  Select Best Answer

rushali_g

 Profile Answers by rushali_g Questions by rushali_g

• Oct 25th, 2009

Analysis, Knowledge Discovery

Answer Question  Select Best Answer

karthik

• Sep 17th, 2007

Because bitmapped indexes map values in the column to bits and store only the bit values, storage is reduced by several orders when bitmapped indexes are used.

Answer Question  Select Best Answer

Satish

• Sep 20th, 2007

Data profiling is a way to find out what is the profile of the information contained in the source. e.g. In a table a column may be defined as alphanumeric. However majority of the data may be numeric...

Answer Question  Select Best Answer

sridhar.gonda

 Profile Answers by sridhar.gonda Questions by sridhar.gonda

• Oct 27th, 2007

Means different technology whr we can share knowledge.

Answer Question  Select Best Answer

How to create parameter file and how to use in a mapping and workflow? Explaon with eg

ARUL_P

 Profile Answers by ARUL_P Questions by ARUL_P

• Jul 28th, 2008

Hi, When a session starts to run, it checks for the database connectivity in the session properties. Alternatively, this details are stored in a Parameter file(a text file) and is stored in a particul...

Answer Question  Select Best Answer

What is the difference between OLAP and OLTP?

Pardeep Kaur

 Profile Answers by Pardeep Kaur Questions by Pardeep Kaur

• Jan 31st, 2008

OLAP stands for online analytical processing . In this we have access to live data. This process contain historical information to analyze. Data needs to be integrated.We can create reports that are m...

Answer Question  Select Best Answer

What is DSTX?

mercmorrow

 Profile Answers by mercmorrow Questions by mercmorrow

• Jan 21st, 2009

Probably a late answer now, but... Datastage TX a rebranding of the Mercator runtime(Event Server) application by the (then) owners Ascential.Since then IBM have taken over Ascential, and the product ...

Answer Question  Select Best Answer

What is a Session log, task in Informatica.
What is the work of Session log and workflow manager.

ambika shanmugam

 Profile Answers by ambika shanmugam Questions by ambika shanmugam

• May 20th, 2008

Session Log:The session log contains the status of  the job whether it is running or abended or good end. And also the information about the every step execution.Task: This is the stage for&...

Answer Question  Select Best Answer