I have a few records all are same structures data, I want to
store data in multiple targets how?
- 4 Answers
- 7205 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 to capture rejected data by using join stage not for lookup stage. please let me know
how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project
Describe the main features of datastage?
Demonstrate experience in maintaining quality process standards?
What is the difference between orabulk and bcp stages?
How can we run same job in 1 day 2 times
which memory is used by lookup and join
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?
Have you used Unstructured data?
in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.
How do you find the number of rows in a sequential file?
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?
Teradata 
