What are the advantages of Data Mining over traditional approaches>

Emanisreddy

 Profile Answers by Emanisreddy Questions by Emanisreddy

• Apr 17th, 2012

Data mining is nothing about analyzing the results with different prospects.

Answer Question  Select Best Answer

How can I load rejected data file?
Is it necessary to create new mapping for that.....How can I load by reject data utility explain me clearly

Read Best Answer

Editorial / Best Answer

joshmohit  

 Profile Answers by joshmohit Questions by joshmohit

• Member Since Oct-2010 | Nov 3rd, 2010

---

Aggregate table is a generic term to represent the summaries built in a warehouse. MAterilaized view is the technical implementation of these aggregate tables. Though, Materialized views come with the database specific properties which might not be covered with the generic definition of aggregate tables.

Tom Haughey

 Profile Answers by Tom Haughey Questions by Tom Haughey

• Apr 30th, 2012

?An aggregate table is a table that contains data that is summarized somehow, for example, it contains a summary of Customer by Product by Week. A more granular level of detail would be the transactio...

joshmohit

 Profile Answers by joshmohit Questions by joshmohit

• Nov 3rd, 2010

Aggregate table is a generic term to represent the summaries built in a warehouse. MAterilaized view is the technical implementation of these aggregate tables. Though, Materialized views come with the...

Improve Answer

PANGANAMALA SRINIVAS

• May 9th, 2012

Fan trap: one of the schema-tables in your physical realization via an rdbms has a 1:many relationship between two slave-tables but there is no path between the two slave tables! So we are clueless ab...

johnftamburo

 Profile Answers by johnftamburo Questions by johnftamburo

• Mar 19th, 2009

A fan trap is a many-to-many relationship between two fact tables, bridged by a dimension.

Answer Question  Select Best Answer

How do we increase Hash file size?

What is the purpose of sequencer and how to create in real time project in parallel?

How to create sequencer in datastage(parallel)?

I have source like a,b,c 1,2,3 I want to populate the records in to target as follows
a 1
b 2
c 3

can any body tell me how to solve the scenario by using Transformer Stage.(In Data Stages)

What is the relationship between company database and its data warehaouse?

Rajarao marisa

• Jun 6th, 2012

Hi, The main diff between database and data warehouse------> DW 1)Its stores historical & Summarized d...

prasadkawade

 Profile Answers by prasadkawade Questions by prasadkawade

• Mar 20th, 2012

Company database contains all the current data. whereas the data warehouse of means data repository. Database stores all the data on which business runs but database repository contains the data that ...

Answer Question  Select Best Answer

What are the types of slowly changingdimension ?Can you explain please types of slowly changingdimension in detail ?

vijaya

• Aug 29th, 2012

Slowly changing dimensions are 3 types. In scd-1 new data is inserted by deleting old one. so latest information is stored. In scd-2 we can maintain history of data for a particular item. new data is...

bhavikumehta

 Profile Answers by bhavikumehta Questions by bhavikumehta

• Jun 26th, 2012

SCD are of following types: type 1 - updates changes without preserving history type 2 - stores history data by maintaining versions of the updated data type 3 - either stores current and previous ver...

Answer Question  Select Best Answer

Janaki

• Nov 5th, 2012

3.Surrogate key is a sequencer which is used to uniquely identify a row in a OLAP. This helps in implementing SCD Type 2 in data warehousing.

rj_dwbi

 Profile Answers by rj_dwbi Questions by rj_dwbi

• Apr 2nd, 2012

OLAP:
1). Store historical data of an organization
2). Data is used for BI/ business strategic decision

OLTP
1). Real time transactional data
2). Data is used to have track of transaction details.

Answer Question  Select Best Answer

In informatica v 8.6
One workflow triggers another workflow.
How where do we put a distinct clause so that the duplicates are not reflected in the report formed by the second WF. first Wf does a partial load

dspgi

• Dec 15th, 2012

Your question is not very clear. However, if you mean to say that you are loading the same target table using two different mappings, then here is the answer. You can use any one of the below approach...

Answer Question  Select Best Answer

Praful

• Dec 17th, 2012

In datastage, we can use the External Filter stage, use the unix command head or tail to retrieve the particular lines from the flat file.

ambika shanmugam

 Profile Answers by ambika shanmugam Questions by ambika shanmugam

• May 20th, 2008

Using the SORT operation, we can retrieve the set of records from the flat file Sample command;SORT FIELDS COPYSTOPAFT=10 (stop after 10th record)SKIPREC=10 (skip first 10 records) 

Answer Question  Select Best Answer

Can any one explain about master data? and we use it frequently or rarely.

As I am new to Informatica. Can anybody tell me about real time
Informatica project in detail(step by step). Explain it by giving example.

How to Create a OCE (Open Catalog Extension) in Hyperion?

Shanmuagapriya K

• Feb 3rd, 2013

Launch IR Studio--Tools---Connection--Create.

Answer Question  Select Best Answer

Sandip More

• Mar 3rd, 2013

You can interact with another co-operating system with setting below parameters in .abinitiorc of existing coperating system : AB_NODE : Node at which this another co-operating system resides AB_HOME...

Answer Question  Select Best Answer

What is the use of the unused port in the join component? We have reject port. Difference between the reject port & unused port?

anshuman trivedi

• Mar 3rd, 2013

Hi, Answer of question is as following. 1)Reject Port:it will contain all the rejected record,here rejection does not means those records which does not follow the join condition,here comes those reco...

Answer Question  Select Best Answer