Rajesh Swarnkar

• Feb 28th, 2012

Data Marts are considered as smaller logical subset of Data warehouse. DW is enterprise-wide while DMs are for Department Level. So DMs can be identified on the basis of what departments are there in Insurance company.
E.g. Sales Department.

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

my Source is like:

Sno Name
1 XXXX
2 YYYY

I want the Target like:

Sno Name Frequency
1 XXXX 1
2 YYYY 2
2 YYYY 2

How can I replicate the "2 YYYY".
I am supposed to make it dynamic for all possible frequencies.

Visal

• Aug 14th, 2016

From what I understood from the scenario given above, you want to duplicate some particular type of record. use Router and write the same condition (say column1=2) for both output group. Remember defa...

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 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

How union transformation is active?

jignesh

• Jan 2nd, 2015

No doubt union transformation will give you the result as a passive transformation with same number of records,But row number of the records will get changed in output result set.....eg we have table ...

Answer Question  Select Best Answer

Harsh

• Dec 2nd, 2014

Alter index rebuild;

Answer Question  Select Best Answer

I have a file with 1000 rows I need to split this file that each 100 row is split by a header, to make more clear I need to concatenate the header after 100 row

Harsha

• Feb 7th, 2018

Take the input to sequential file ,in that in filter opinion mention head -100 and output connect it to column import where you mention the schema of input and mention the output schema u need ..so it concatenates entire thing into single row/column.

Correct me if im.wrong.

Answer Question  Select Best Answer

shaik

• May 6th, 2006

Subject Area is place where  we draw the entities and attributes of the dimensions and fact table with relationships in ERWIN

girish

• Mar 16th, 2006

Dimension modelling is brokent into subject Areas which are nothing but functional areas of an enterprise.

Answer Question  Select Best Answer

anilkumar.inf

 Profile Answers by anilkumar.inf Questions by anilkumar.inf

• Apr 11th, 2007

DTM Stands fo data transformation managerit is a process which runs secondly with every session runit creates main thread for running the session and the main thread creates seperate threads for each ...

sithu

 Profile Answers by sithu Questions by sithu

• Mar 28th, 2006

?          The DTM process - Creates threads to initialize the session, read, write, and transform data, and handle pre- and post-session operations? ...

Answer Question  Select Best Answer

shaik

• May 6th, 2006

Take a union transformation and take three working dimensions of three different location  and filter the data and draw a dimension and fact according to specification

sithu

 Profile Answers by sithu Questions by sithu

• May 2nd, 2006

Hi Palani,you define a object(flag) to find out the EMP location on for a particular date/time{he could not able to be in two place at one time }, with use of your time Dimesion write a condition, you will get the ResuleCheers,Sithu, sithusithu@hotmail.com

Answer Question  Select Best Answer

ravi_kumar_garre

• Nov 11th, 2007

In Business Objects Universe Designer you can open Table Browser and select the tables needed then insert them to designer.

sithu

 Profile Answers by sithu Questions by sithu

• Sep 12th, 2006

hi,Just right click in your designer and insert table,Cheers,Sithu, sithusithu@hotmail.com 

Answer Question  Select Best Answer

ravi_kumar_garre

• Nov 11th, 2007

In Business Objects unvierse creation we do have two types of Hierarchies Custom and Default Hierarchies. Default hierarchies are by default all objects in a given class. For example Time Dimension. By default you can define Time Dimension Year, Quarter, Month and Day.

jahnavi.s

 Profile Answers by jahnavi.s Questions by jahnavi.s

• Sep 20th, 2006

The galaxy schema is also know as fact constellation scheme.it requires no of fact tables to share dimension tables.in dataware housing mainly the people are using theconceptual hierarchy

Answer Question  Select Best Answer

jyothi

• Feb 10th, 2007

Hierarchical level of datawarehousing is nothing but the concept of generalization and specialization.As we move up the hierarchy the data is more generalized for ex : the location where STATE is more...

opbang

 Profile Answers by opbang Questions by opbang

• Sep 29th, 2006

In Datawarehousing, Levels are columns available in dimension table. Levels are having attributes.Hierarchies are used for navigational purpose, There are two types of Hierarchies. You can define hier...

Answer Question  Select Best Answer

Guest

• Jan 16th, 2007

Data modelling is nothing but optimizing the data in ods for further analysis ..which is carried out by diffrent algorthims..etc..Data mining is nothing but finding intersting pattern,trends..new defnition to the data and create BI out of it .

srinvias vadlakonda

• Oct 17th, 2006

Data modeling is the process of designing a data base model. In this data model data will be stored in two types of table fact table and dimention tablefact table contains the transaction data and dim...

Answer Question  Select Best Answer

jyothi

• Feb 10th, 2007

1) Data Warehouse architecture is a three tire architecture where there are three tires i) bottom tire : it contains the gateways where they provide the interface b/w the data and the s/m ii) m...

srinivas vadlakonds

• Oct 17th, 2006

1) Data warehousing is the repository of intgrated information data will be extracted from the heterogeneous sources. Data warhousing architecture contains the different  sources like oralc,flat ...

Answer Question  Select Best Answer

Uma

• Oct 10th, 2007

Drill across corresponds to switching from 1 classification in 1 dimension to a different classification in different dimenstion.

jyothi

• Feb 12th, 2007

Drilling across is a process of moving down in the Hierarchy........where one can see the more generalized way of viewing the information.........ex : The year represented in quarter could be drilled across by specifying each month......

Answer Question  Select Best Answer

surender.Vanga

• Sep 18th, 2011

Here are some questions... (I am assuming that you are asking about Informatica data quality) 1. What are the most used transformations in IDQ? 2. What is address doctor? 3. Can we export an object fr...

ravi_kumar_garre

• Nov 11th, 2007

Interview questions for Data Quality Analyst are as follows:1. How can you say there are no duplicate records in Data warehouse?2. Whether the ETL job accepts known accept records?3. What are the Data Quality Tools? e.g. BO Data Quality, First Logic..etc

Answer Question  Select Best Answer

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Nov 11th, 2007

Core Dimension is a Dimension table which is used dedicated for single fact table or Datamart. Conform Dimension is a Dimension table which is used across fact tables or Datamarts.

sar

• Apr 21st, 2007

Universe does not hold any data. however practically the universe?is known to have?issues when the objects cross 6000.

Answer Question  Select Best Answer

pradeep.dwh

 Profile Answers by pradeep.dwh Questions by pradeep.dwh

• Jan 26th, 2008

For better performance

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Nov 11th, 2007

Why you wanted to partition the Unvierse?Regards,Ravi Kumar Garre

Answer Question  Select Best Answer