iam new to datastage...now i want to know what are fact
tables, dimension tables in bank domain...if any body knows
plz tell me asap..

Answer Posted / subhash

FACT Table:(Daily transaction details)
Transaction_Details

Dimension Tables:(Which have static data)

Customer_details
Account_Details

DATE & TIME

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to sort two columns in single job in datastage.

2555


What is the differentiate between data file and descriptor file?

875


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1484


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

1812


Define repository tables in datastage?

713






Explain the situation where you have applied SCD in your project?

1572


What are the different types of lookups in datastage?

639


What are the some differences between 7.x and 8.x version of datastage?

753


How you Implemented SCD Type 1 & Type 2 in your project?

3705


How to reverse the string using SQL?

907


Can we use target hash file as a lookup ?

2828


How rejected rows are managed in datastage?

937


Distinguish between informatica & datastage. Which one would you choose and why?

596


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

642


How many types of sorting methods are available in datastage?

642