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
- 8853 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How will you move hashed file from one location to another location?
What are stage variables and constants?
What is the difference between the local container and shared container?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is a ds designer?
options available in sequence job to run,validate?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
project Steps,hits, Project level HArd things,Solved methods?
Notification Activity
Explain the importance of surrogate key in data warehousing?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What are the types of jobs we have in datastage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are iconv and oconv?
What are the various kinds of containers available in datastage?
