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

What are lookup tables? Why they are used? Where they are used?

ponnarasuk

 Profile Answers by ponnarasuk Questions by ponnarasuk

• Jul 9th, 2008

When a foreign key exists in a table, the foreign key’s table is sometimes referred to as a lookup table. The DEPARTMENT table in our example is a lookup table for the EMPLOYEE table. The value of an employee’s department can be looked up in the DEPARTMENT table

Answer Question  Select Best Answer

What is the difference between OLAP tools and reporting tools?

sinisdevan

 Profile Answers by sinisdevan Questions by sinisdevan

• Jul 10th, 2008

By using OLAP tools you will be able to create a symantec layer of datamarts on which we can run reports.

Answer Question  Select Best Answer

How to Pivot a table inside informatica?
Allowing data spread across multiple rows to be inserted into a single row in a different table.Col A Col B A 10 B 20After pivoting (Target Table)ID Value A Value B1 10 20How can this be achieved inside informatica?

devidya

 Profile Answers by devidya Questions by devidya

• Sep 25th, 2008

Use a router to denormalize the data and then merge them using a union transfomation. I think this is one of the ways to do it. All the Best.

Answer Question  Select Best Answer

Illustrate one detailed example for multi-valued dimension or bridge table?

ramanapaidi

 Profile Answers by ramanapaidi Questions by ramanapaidi

• Jul 1st, 2009

Health care bill has line item of diagnosis, for which there could be multiple values 

Answer Question  Select Best Answer

When is the need to do OOAD (Object oriented analysis & design)

subang

 Profile Answers by subang Questions by subang

• Jan 17th, 2010

We use OOAD in order to design the system when overall requirements needed for developing the new system are clearly understood by the developer.

Answer Question  Select Best Answer

If you take a print out of your model in ERWIN tool, What all you will be able to see?

rajeshkumar.san

 Profile Answers by rajeshkumar.san Questions by rajeshkumar.san

• Dec 26th, 2008

According to the selection of print we can view in the print out. we will be able to view all the tables with their feild name, primary key, datatype, relation between the tables and their flow.

Answer Question  Select Best Answer

How anyone define the pracical difference between Kimball & Inmon?

Read Best Answer

Editorial / Best Answer

shashk  

 Profile Answers by shashk Questions by shashk

• Member Since Jul-2010 | Aug 25th, 2010

---

Bill Inmon's paradigm: Data warehouse is one part of the overall business intelligence system. An enterprise has one data warehouse, and data marts source their information from the data warehouse. In the data warehouse, information is stored in 3rd normal form.

Ralph Kimball's paradigm: Data warehouse is the conglomerate of all data marts within the enterprise. Information is always stored in the dimensional model.

There is no right or wrong between these two ideas, as they represent different data warehousing philosophies.
In reality, the data warehouse in most enterprises are closer to Ralph Kimball's idea. This is because most data warehouses started out as a departmental effort, and hence they originated as a data mart. Only when more data marts are built later do they evolve into a data warehouse.

shashk

 Profile Answers by shashk Questions by shashk

• Aug 25th, 2010

Bill Inmon's paradigm: Data warehouse is one part of the overall business intelligence system. An enterprise has one data warehouse, and data marts source their information from the data warehouse...

Improve Answer