What are lookup tables? Why they are used? Where they are used?

ponnarasuk

 Profile Answers by ponnarasuk Questions by ponnarasuk

• Jul 9th, 2008

When a foreign key exists in a table, the foreign key’s table is sometimes referred to as a lookup table. The DEPARTMENT table in our example is a lookup table for the EMPLOYEE table. The value of an employee’s department can be looked up in the DEPARTMENT table

Answer Question  Select Best Answer

What is the difference between OLAP tools and reporting tools?

sinisdevan

 Profile Answers by sinisdevan Questions by sinisdevan

• Jul 10th, 2008

By using OLAP tools you will be able to create a symantec layer of datamarts on which we can run reports.

Answer Question  Select Best Answer

How to Build Time Dimenion in Datawarehousing?

How you differentiate between SOA & Web Services?

Where exactly do you use XML, XSLT, X-PATH, X-QUERY & BPEL

How to create parameter file and how to use in a mapping and workflow? Explaon with eg

ARUL_P

 Profile Answers by ARUL_P Questions by ARUL_P

• Jul 28th, 2008

Hi, When a session starts to run, it checks for the database connectivity in the session properties. Alternatively, this details are stored in a Parameter file(a text file) and is stored in a particul...

Answer Question  Select Best Answer

What are the difference between a database and data warehouse?

gtomar

 Profile Answers by gtomar Questions by gtomar

• Jul 28th, 2008

Database :- database is a collection of related information stored in a structured form in terms of table so that It makes easier insertion, deletion and mainupulation of data. database consist of tab...

ashuboy12345678

 Profile Answers by ashuboy12345678 Questions by ashuboy12345678

• Jul 27th, 2008

Database is a collection of mostly recent data. Where as Datawarehouse consist of historical data the size can vary upto 100 GB or more.Datawarehouse is a combination of datamart used mainly knowledge processing.

Answer Question  Select Best Answer

What is Cardinality? What are the different types of Cardinality? How will you define Cardinality to outer join, left join, right join, inner join, fact to fact and dimension to dimesion?

How could you tell whether a system was regular TBX, micro BTX, or pico BTX?

How to Pivot a table inside informatica?
Allowing data spread across multiple rows to be inserted into a single row in a different table.Col A Col B A 10 B 20After pivoting (Target Table)ID Value A Value B1 10 20How can this be achieved inside informatica?

devidya

 Profile Answers by devidya Questions by devidya

• Sep 25th, 2008

Use a router to denormalize the data and then merge them using a union transfomation. I think this is one of the ways to do it. All the Best.

Answer Question  Select Best Answer

What is Real-Time Data Warehousing?

How to create content store in the network and how to connect the remote database?

How to use version control. What are the options which is use in the version control

tisha24

 Profile Answers by tisha24 Questions by tisha24

• Dec 18th, 2008

One more is there, known as "GALAXY SCHEMA"

uma

• May 17th, 2007

There are 3 types of schemasstar schemasnowflake schemaand galaxy schemabyuma

Answer Question  Select Best Answer

If you take a print out of your model in ERWIN tool, What all you will be able to see?

rajeshkumar.san

 Profile Answers by rajeshkumar.san Questions by rajeshkumar.san

• Dec 26th, 2008

According to the selection of print we can view in the print out. we will be able to view all the tables with their feild name, primary key, datatype, relation between the tables and their flow.

Answer Question  Select Best Answer

What is DSTX?

mercmorrow

 Profile Answers by mercmorrow Questions by mercmorrow

• Jan 21st, 2009

Probably a late answer now, but... Datastage TX a rebranding of the Mercator runtime(Event Server) application by the (then) owners Ascential.Since then IBM have taken over Ascential, and the product ...

Answer Question  Select Best Answer

How data security is provided in Data Warehouse?

How to compare values in data table?

What is the life cycle of Data Warehousing in Real-time?

dhiveya.m

 Profile Answers by dhiveya.m Questions by dhiveya.m

• Apr 22nd, 2009

Mapping parameter are the constant values (values never changes) and mapping variables are the values that ever changes.

fir_dan

 Profile Answers by fir_dan Questions by fir_dan

• Jul 18th, 2008

A mapping parameter is a static value that you define before running the session and it retains the same value till the end of the session. Define a parameter in paramaeter file (.par) and use it in m...

Answer Question  Select Best Answer