1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

which dim, fact tables used in bank domain

Question Posted / gopipalem


which dim, fact tables used in bank domain..

Answer / nams

Date_Dim, Cstomer_Dim, State_Dim, Country_Dim, City_Dim, Area_Dim, Invoice_Dim, Trannsaction_Dim

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Data Stage Interview Questions

Differentiate between datastage and informatica?

0 Answers  

Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?

1 Answers   TCS,

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

0 Answers  

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

0 Answers   CTS,

Define meta stage?

0 Answers  




i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?

4 Answers   L&T,

what is operator combinality in datastage?

1 Answers   TCS,

What steps should be taken to improve Datastage jobs?

0 Answers  

In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..

2 Answers  

If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?

5 Answers   Infotech,

Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

1 Answers   Alpharithm Technologies,

What are some different alternative commands associated with "dsjob"?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories