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 / bhargavi
Facts are numeric values (or) daily transactions done to any
business.
Dimensions are detail information about business
E.g.,: cust no,customer name,addr...
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
On which Dimension Table you implemented SCD Type in your Project
Why do we use exception activity in Datastage?
What all the types of jobs you developed?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What are system variables and sequencers in datastage
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Why fact table is in normal form?
What are some different alternative commands associated with "dsjob"?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
If you want to use the same piece of code in different jobs, how will you achieve it?
If you want to use a same piece of code in different jobs, how will you achieve this?
Can we use target hash file as a lookup ?
Explain the importance of surrogate key in data warehousing?
How to reverse the string using unix?
What is the roundrobin collector?