I have a few records all are same structures data, I want to
store data in multiple targets how?
- 4 Answers
- 7656 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 many datamarts we will use in real time project and when will use the datamart?pls send the replay early
Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?
how can u handle null values in transformer stage.
What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?
What are the partitioning techniques available in link partitioner?
1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran
Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?
15 Answers Scope International,
Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?
How can we improve performance of data stage jobs?
I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A
What are sequencers?
How can we improve the performance in datastage?
Teradata 
