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
I have a few records just I want to store data in to targets cycling way how?
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?
we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?
diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?
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)
explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT
why we use hash file for lookup?
How many types of stage?
How to lode data in sequntional files perform faster?
I want capture UnMatched records from Primary source and secondary source in JOIN stage?
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.