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?

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

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

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

How you differentiate between SOA & Web Services?

How to Build Time Dimenion in Datawarehousing?

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

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

How to prepare dimensional model for internet sales?What are the business requirements for internet marketing/sales/

What is a Session log, task in Informatica.
What is the work of Session log and workflow manager.

ambika shanmugam

 Profile Answers by ambika shanmugam Questions by ambika shanmugam

• May 20th, 2008

Session Log:The session log contains the status of  the job whether it is running or abended or good end. And also the information about the every step execution.Task: This is the stage for&...

Answer Question  Select Best Answer

How to deploy the report in Report Studio?

What are the differences between Meta Data and Data Dictionary?

jryan999

 Profile Answers by jryan999 Questions by jryan999

• May 1st, 2008

The “data dictionary” in a database tool (eg. Oracle or Informatica) is simply a repository of metadata. Metadata is however data about the data.  The following are examples of m...

pal.amol

 Profile Answers by pal.amol Questions by pal.amol

• Feb 26th, 2008

HI  Metadata is nothing but the data about data , if you take term of informatica in that through metadata only you will be converting or solving the problem. In the flow of Informatica mapp...

Answer Question  Select Best Answer

rmanikandan

 Profile Answers by rmanikandan Questions by rmanikandan

• Apr 30th, 2008

Data warehousing is used to perform Historical records & providing all information by client users. Yes we can persom all the transformatioin usring oracle

prudhvi.g

• Sep 3rd, 2007

Datawarehousing is nothing but analysing the data and providing solutions to the business people.Major usage of datawarehousing is that it can analyse the data and stored the data which is historical.

Answer Question  Select Best Answer

VVM.SP

 Profile Answers by VVM.SP Questions by VVM.SP

• Mar 18th, 2008

In Filter Transformation Those row are not meet to the filter condition they are rejected.  These rejected rows are appear in $PMBad.Dir

herbert

• Dec 9th, 2006

Yes there is  folder or file in informatica which collects this rejected rows, its location is given while installing the s/w

Answer Question  Select Best Answer

VVM.SP

 Profile Answers by VVM.SP Questions by VVM.SP

• Mar 13th, 2008

It is a column, which we when update the OLTP

Anitha

• Feb 23rd, 2007

The columns(granular) that change the values over a perriod of time.

Answer Question  Select Best Answer

How to create parameters in concurrent program for "HOST" executable type

praveen.p

 Profile Answers by praveen.p Questions by praveen.p

• Mar 9th, 2008

Use a bridge table.. as simple as that.

gopal

• Jan 25th, 2007

HiUpto my knowlege designers implementing this M-M relation asFirst break the schema to 1-M and M-1 relationsLet me correct if any thing is wrong

Answer Question  Select Best Answer

What is the difference between Clustering and Sampling

26rajj

 Profile Answers by 26rajj Questions by 26rajj

• Mar 8th, 2008

Data mart is a subset of dwh

surajkm99

 Profile Answers by surajkm99 Questions by surajkm99

• Feb 4th, 2008

1)  Difference Between Data Warehouse & Data MartIn Simple Terms Data warehouse : is a SUBJECT - ORIENTED, TIME VARIENT, NON-VOLATILE, INTEGRATED Collection of Data, In Support of Management ...

Answer Question  Select Best Answer