Interested to Buy Any Domain ? << Click Here >> for more details...
I have a few records all are same structures data, I want to
store data in multiple targets how?
- 4 Answers
- 8670 Views
- Polaris, I also Faced
- E-Mail Answers
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 WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
How to get max salary of an organization using data stage stages........... can any body help me plz.......
i have flat file and using unix how can i generate sequence number into targer?
i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb
In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.
How do u convert the columns to rows in datastage?
How and where you used hash file?
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me
I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
why we use hash file for lookup?
How to RD using transformer?
Teradata 
