how many dimentions and fact tables used in your project and
what are names of it?
Answers were Sorted based on User's Feedback
Answer / raj
Product Dimension : Product Key, Product id, Product Type, Product name, Batch Number.
Distributor Dimension: Distributor key, Distributor Id, Distributor Location,
Customer Dimension : Customer Key, Customer Id, CName, Age, status, Address, Contact
Account Dimension : Account Key, Acct id, acct type, Location, Balance
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / archana
hi raj,
where is the fact tables,can u tell me the fact tables desc also.thanks in advance
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / avinash(datastage proff)
anybody knows it pls send rep fast
Is This Answer Correct ? | 3 Yes | 6 No |
Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.
how to call sequential generator in datastage?
what is the use of invokation id
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 does work server jobs?
In Datastage, how you can fix the truncated data error?
What can we do with datastage director?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
How and where you used hash file?
What is the sortmerge collector?
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?