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

I have a few records just I want to store data in to targets cycling way how?

0 Answers   Polaris,


what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

1 Answers   Wipro,


I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?

2 Answers  


we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

1 Answers   HSBC, NTT Data,


diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?

1 Answers   TCS,






Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)

1 Answers   IBM,


explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT

3 Answers   IBM, Polaris,


why we use hash file for lookup?

5 Answers  


How many types of stage?

0 Answers  


How to lode data in sequntional files perform faster?

1 Answers   Polaris,


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

3 Answers   TCS,


Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.

3 Answers   Cognizant, UHG,


Categories