I have a few records all are same structures data, I want to
store data in multiple targets how?
Answers were Sorted based on User's Feedback
Answer / raman
Use the same job for loading by parameterizing the file
name the table name.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / geetha
Use transformer stage and modulus function. Lets say we have 4 target tables and set constraint to each target links as below.
Link1--> mod(@INROWNUM,4)=0
Link2--> mod(@INROWNUM,4)=1
Link3--> mod(@INROWNUM,4)=2
Link4--> mod(@INROWNUM,4)=3
we can also use filter stage and where clause to split the records
Is This Answer Correct ? | 2 Yes | 0 No |
HOW CAN WE SEE THE DATA IN DATASET?
Describe the architecture of datastage?
options available in sequence job to run,validate?
What is PX?
How do you run datastage job from the command line?
hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..
Can you implement SCD2 using join, transformer and funnel stage?
while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance
souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
i want job aborted after some records are loaded into output by using only sequential stage and dataset