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

nitesh

• Aug 10th, 2007

Data analysis explains the overall performance of a business organization data can be analyzed based on the ETL tools operations like informatica, data staging...) and the reports generated by the OLAP

mithunmca

 Profile Answers by mithunmca Questions by mithunmca

• Mar 22nd, 2007

data analysis: consider that ur are running a business and u store the data of that  in some form say in register or in a comp and at the year end you want know the profit or loss then it ca...

Answer Question  Select Best Answer

GOPINATH

• Nov 20th, 2006

Question: 1)After the complete genaration of a report who will test the report and who will analyze it.2)After the genaration of a report to whom we have to deploy or what we do after the completion of a report.

khajapeer

• Nov 18th, 2006

hiafter the completion of reporting, the reports will be sent to business analysts who will analyze the data from different points of view so that they can make a proper business decisions.the generated report will be sent to the concerned business users through web or lan

Answer Question  Select Best Answer

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Nov 11th, 2007

Generation of CUBES is also a multiDimensional technique. You can reply if you are looking for more details.Regards,Ravi Kumar Garre

herbert

• Dec 9th, 2006

Eg:slice and dice

Answer Question  Select Best Answer

ATTILI

• Mar 19th, 2007

Cluster analysis is an exploratory data analysis tool which aims at sorting different objects into groups in a way that the degree of association between two objects is maximal if they belong to the same group and minimal otherwise

Guest

• Jan 16th, 2007

Cluster analysis discovers structure in the data we have without explaining why they exist.There are diffrent types of clustering techniques a)block clustering       &nbs...

Answer Question  Select Best Answer

fiorano

 Profile Answers by fiorano Questions by fiorano

• Aug 1st, 2007

metadata is :The data about data;The structured data about data;A set of independent assertions about a resource.DD is :An intergrated set of system tables;contains definitions of and information abou...

sreenivasamurthy

 Profile Answers by sreenivasamurthy Questions by sreenivasamurthy

• Jun 22nd, 2007

meta data is nothing but  information about data.it contains the information(i.e.data) about the graphs ,its related files,abinitiocommands,serverinformation etc i.e. all kinds of information about project related information etc

Answer Question  Select Best Answer

prudhvi.g

 Profile Answers by prudhvi.g Questions by prudhvi.g

• Sep 3rd, 2007

IQD means Impromptu Query Definition file.These IQD files are main inputs to the cubes in Power play Transformer.

zohaib

• Aug 23rd, 2007

The iqd file describes the query and is used by other Cognos products when they drill through to the query!!

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