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 |
6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment
how many datamarts we will use in real time project and when will use the datamart?pls send the replay early
I have a few records just I want to store each records tow times in target how?
Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.
how to sort two columns in single job in datastage.
Define project in datastage?
how to convert rows into columns
what is a nodemap constraint
CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....
What are the types of containers?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.