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
- 8907 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 |
how to remove duplicates in transformer stage by using stage variables?one example?
what is mapping lookup
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is a quality stage in datastage tool?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
difference between function and procedure...
HOW CAN WE SEE THE DATA IN DATASET?
12 Answers IBM, TCS,
What are the steps needed to create a simple basic datastage job?
What is a range lookup?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables?chandu how can i implement scd typ1 and type2 in both server and in parallel?chandu field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the ,inthe fields?
source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.
Define Job control?
Teradata 
