Hi,can any one please mention list of dimension and fact
tables for Sales and Distribution System for a
Pharmacutical company.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Stage Interview Questions

How many types of stage?

0 Answers  


Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)

3 Answers   HSBC,


How to remove ctrl M or(^M) characters in file using Sequential File stage?

2 Answers   Bank Of America, Satyam,


what is the use of surogate key in datastage

3 Answers  


how many types of remove the duplicate records?

3 Answers   Caterpillar,






Demonstrate experience in maintaining quality process standards?

0 Answers   iGate,


What is the purpose of pivot stage and types of containers in datastage

0 Answers  


How to add zero "0" before record in a field?

4 Answers  


In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?

2 Answers   Polaris,


source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?

2 Answers   Wipro,


In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..

2 Answers  


Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.

7 Answers  


Categories