how many dimentions and fact tables used in your project and
what are names of it?




Answers were Sorted based on User's Feedback



how many dimentions and fact tables used in your project and what are names of it?..

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

how many dimentions and fact tables used in your project and what are names of it?..

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

how many dimentions and fact tables used in your project and what are names of it?..

Answer / avinash(datastage proff)

anybody knows it pls send rep fast

Is This Answer Correct ?    3 Yes 6 No



Post New Answer



More Data Stage Interview Questions

i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00

2 Answers  


If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

2 Answers   TCS,


How you Implemented SCD Type 1 & Type 2 in your project?

0 Answers  


my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?

10 Answers   Polaris,


Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

3 Answers   IBM,






what is the use of surogate key in datastage

0 Answers   TCS,


Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

4 Answers   UHG,


which is the most complex job in your career? Please tell me answer?

2 Answers   IBM, Wipro,


I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,


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,


4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 please send me answer this question my mail

1 Answers  


what is the use of DSattchJob?DetachJob? where can we find it?

0 Answers   IBM,






Categories