Liam Whales

• Mar 24th, 2014

Anything that can always be uniquely generated and bears no relation on the underlying data

Aswin

• Feb 4th, 2014

Why cant we use a GUID? which is more powerful and have good uniqueness

Answer Question  Select Best Answer

Liam Whales

• Mar 24th, 2014

Moving from one software or hardware platform to another. Rather than the usual functional changes the aim is to keep the system functionally the same but move to the new platform.

JavidJaffer

• Jan 14th, 2014

System Conversion: is a common layman word, which has meany meanings to it: It can be: 1. Either Hardware Upgrade (Machines, Servers, LAN, Router, Switches) due to their Expansions in terms of volume...

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

What is external table in oracle?How oracle read flat file?

sheraz baig

• Nov 20th, 2013

External Tables let you query data in a flat file. In 9i, only read operations were permitted; in 10g, you can also write out data to an external table. While external tables can be queried, theyre no...

Answer Question  Select Best Answer

Karthikeyan E

• Oct 21st, 2013

RAID 1 --- Additional disk which stores the mirror image of original disk data.

RAID 5 - Uses XR algorithm and retrieves records when original disk failure.

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Jan 4th, 2008

The basic advantage of RAID is to speed up the data reading from permanent storage device (hard disk). Cheers,Ravi Kumar Garre

Answer Question  Select Best Answer

What are the types of dimensions? Can you explainthe each type in short?

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Aug 28th, 2013

Conformed Dimension: Used across lines of businesses to gather information from across LOBs. Eg. if we want to know the deptnames where the avg salary of employees is more than the overall avg. Junk D...

Joe

• Aug 21st, 2012

1. Conformed Dimensions
2. Junk Dimensions

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

What are the various OLAP & MOLAP operations?

mohan

• Mar 20th, 2013

Olap means online analytical processing its mainly used for ssas and then molap means multidimensional online analytical processing its different to olap

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

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

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

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.

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

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

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

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

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

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