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 |
How do you import and export data into datastage?
Which commands are used to import and export the datastage jobs?
How to add zero "0" before record in a field?
explain unit testing,systemtesting,integrated testing
What all are the different way to run a job?
What are stage variables and constants?
1)Source file contains one record, I want 100 records in target file.
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?
how to find out number of records imported into source file?
Define meta stage?
how to abort the job its matain duplicates?
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.