what is time dimension? and how to populate time demension
Answers were Sorted based on User's Feedback
Answer / vijaya
Hi
Every DWH has time dimension u can load the time dimension
though pl/sql script.
Is This Answer Correct ? | 7 Yes | 2 No |
In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario
diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?
HOW CAN WE SEE THE DATA IN DATASET?
12 Answers IBM, TCS,
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
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 ?
How do you run datastage job from the command line?
Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is Empno 1 2 3 4 5 6 7 8 9 10
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?
Hi Vijay here For Four CPU's how many nodes will required?
Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari
How to read multiple files using a single datastage job if files have the same metadata?
Give an idea of system variables.