Interested to Buy Any Domain ? << Click Here >> for more details...
5) A file contains 10 (1-10) I want trgt like
Trgt 1 trgt 2 trgt 3
1 2 3
4 5 6
7 8 9
10
- 4 Answers
- 8697 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / venkatesh
the flow will be like this
source---->transformer----->t1
--------->t2
----------->t3
in transformer create a stage variable which holds the value
of mod(id,3) for instance it will be like this
mod(ds.link2.inputrow id,3) |stgvar
______________________________________________|__________
|
use this stage variable in constraint as
ds.link4 stgvar=1
ds.link5 stgvar=2
ds.link6 stgvar=0
connect the input to the output in transformer
u will get the desired output
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / joe
we can use a transformer with constraint mod(@INROWNUM,3)=2
for trgt1,, =1 for Trgt2, =3 for Trgt3
| Is This Answer Correct ? | 4 Yes | 3 No |
source file contains 100 records, i want 10 records in target file how it possible in datastage
If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?
I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know
What are the processing stages?
What are stage variables and constants?
What are the prerequisites for join stage
Difference between data warehousing and olap?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
what is sparse lookup?
Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please
Define repository tables in datastage?
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
Teradata 
