my source seq file have
col1
1
2
3
4
5
6
7
8
9
i have 4 targets
t1 t2 t3 t4
1 2 3 4
5 6 7 8
9 like this how we can get?
Answers were Sorted based on User's Feedback
Answer / venkatesh
the flow is like this
source---->transformer-------->t1
----------->t2
-------------->t3
------------------>t4
in transformer create a stage variable to calculate mod value
mod(input,4) | mod_value
_________________|____________
in constrain write the condition as
mod_value =1 for t1
mod_value=2 for t2
mod_value=3 for t3
mod_value=0 for t4
try this u will get the required o/p
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / abd
We can use stage variable in Tran Stage
IF @INROWNUM MOD 4 = 0 then T4
Else If @INROWNUM MOD 4 = 1 then T1
Else If @INROWNUM MOD 4 = 2 then T2
Else If @INROWNUM MOD 4 = 3 then T3
Try this
Is This Answer Correct ? | 7 Yes | 2 No |
Answer / srikanth
hi
it is possible by using transform stage
select the function in that select the mathematical in that
select the mod function and run the job
you will get the answer
Thanks & regards
srikanth.k
9573056597
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / jyothi
how this scenario without using MOD operator
if any body know plzzzz tel me...
Is This Answer Correct ? | 0 Yes | 0 No |
as for as i know,it is simple task only,
order is seq_file->column_generator->tfx->connect 4 targets.
in CG take one more column as SNO(anything)and goto extended column properties- take value=1,value=2,,,upto 4. now write constraint in tfx sno=1 goto t1
sno=2 goto t2...for all targets(4).
if u get other tahn this pls post answer
Is This Answer Correct ? | 3 Yes | 6 No |
Answer / srikanth
it's a very simple task
select the partition type as round robin
and run the job
you will get the answer
thanks& regards
srikanth
9573056597
Is This Answer Correct ? | 5 Yes | 11 No |
i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?
Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)
which unix commands mostly used in datastage
What is the difference between in process and inter process?
What are the different database update actions available?
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...
how will u design file watch jobs?
i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
Differentiate between datastage and informatica?
i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?
table actions available in oracle connector?
How do u convert the columns to rows in datastage?