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)

How to create sequencer in datastage(parallel)?

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

How do we increase Hash file size?

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

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

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

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 you say Relational is Normalized one and Data Warehouse i.e Dimensional modeling is De-Normalized one when both model follows the Primary Key Concept in its table to store Data

Iftikhar Alam

• Apr 8th, 2012

Data obtain from transactional source which is normalized on 3NF. It has been staged and demoralized the data and after denationalization of data re-normalized on 2NF and 3NF. Therefore, It is called Demoralized but it is normalized not like the transactional

madhavig

 Profile Answers by madhavig Questions by madhavig

• Feb 16th, 2010

Dimensional modeling usually does with 2NF for dimensions and 3NF for facts.Dimensions are de-normalized for better query performance and for better understanding by business users.

Answer Question  Select Best Answer

Why do we use Surrogate Key?

Rajesh Swarnkar

• Feb 28th, 2012

Usually Surrogate keys are System Generated keys that can be used in place of missing primary key.

sadique_ghitm

 Profile Answers by sadique_ghitm Questions by sadique_ghitm

• Nov 25th, 2011

A surrogate key in a database is a unique identifier for either an entity in the modeled world or an object in the database. The surrogate key is not derived from application data. A surrogate repres...

Answer Question  Select Best Answer

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

How to pass first, Middle and last record in flat file to flat file?

KVR Prasad

• Dec 1st, 2011

By using sequence generator, Expression transformation and router T/R it will be possible.

Answer Question  Select Best Answer

What difference between dimension and hierarchy>What is mean by maxl?difference between esscmd and maxl?If we are using only dense dimension in outline what will be effect of cube structure?

Sahil

• Oct 25th, 2011

Dimensions are like your lookup tables and Hierarchies forms Dimensions. Inside dimensions there exists hierarchies. Example Employee is a dimension , inside Employee dimensions there can be hierarchies such as Directors hierarchy, Managers Hierarchy and employees Hierarchy etc.,,

karna.siva

 Profile Answers by karna.siva Questions by karna.siva

• May 20th, 2008

A dimention is nothing but a subject oriented meta data, just like hr section, employees section etc.  and the hierarchy is depend on the data source, like "hour glassmodel"Account dime...

Answer Question  Select Best Answer

What is the difference between replicate and broadcast ?

chandana

• Sep 21st, 2011

Replicate supports the component parallelism and broadcast supports data parallelism i.e fan-out,all-to-all.

zann1

 Profile Answers by zann1 Questions by zann1

• Sep 7th, 2009

Replication moves data to a specified target, usually at a specified time, and usually is usually defined by the ETL team or DBA. Broadcast moves data to targets in the system as needed, and is usuall...

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

How to partition a cube in analysis services?

Rambabu Kola

• Sep 7th, 2011

-->create cube using ssas and deploy it.
-->connect sql server management studio
-->then connect sql server analysing services
-->right click on cube and click partition
----------------------------------------------------------------
like this we can partition the cube..

Answer Question  Select Best Answer

When do we use Degenerated Dimension?

pradeep reddy gade

• Jul 21st, 2011

Any values in the fact table that dont join to dimensions are either considered degenerate dimensions or measures

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

What is the use of Degenerated dimension? Where it is used?

gargupendar

 Profile Answers by gargupendar Questions by gargupendar

• Mar 24th, 2011

A degenerate dimension is a dimension which is derived from the fact table and doesn't have its own dimension table.Example : Receipt number is the perfect example for degenerate dimension.

Answer Question  Select Best Answer

joanitah

 Profile Answers by joanitah Questions by joanitah

• Mar 12th, 2011

This is a process and outcomes of modeling a logical database schemas created to support OLAP and data warehousing solutions.

Hakoonamatata

 Profile Answers by Hakoonamatata Questions by Hakoonamatata

• Jul 9th, 2007

Here's a different way to look at dimensional modelling:Consider data to be a flat table for now. It would have some columns that contain numbers that need to be used in calcualtions later (e.g. b...

Answer Question  Select Best Answer