my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1

Categories >> Software >> Data Warehouse >> Data Stage
Suggest New Category

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?

Question Posted / vkrish

10 Answers
16802 Views
Polaris, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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 ..

Answer / vamsi

hi,
srikanth

it 's not possible by using round robin , round robin can send recordes to nodes not to target..

if we can use collection methodes also we have 3 targets ,it's not possible

Is This Answer Correct ?

11 Yes

3 No

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 ..

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

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 ..

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

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 ..

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

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 ..

Answer / vamsi

hi.,
srikanth

can u plz explain in detail...........

Is This Answer Correct ?

0 Yes

0 No

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 ..

Answer / jyothi

how this scenario without using MOD operator
if any body know plzzzz tel me...

Is This Answer Correct ?

0 Yes

0 No

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 ..

Answer / bharath

It worked out for round robin also.. plz try..

Is This Answer Correct ?

1 Yes

3 No

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 ..

Answer / bharath

Hi,

try this,

take two sequntial files, one as source and another as target
as follows

src_seq------------------->tgt_seq

in target give 4 target *.txt files.
give partition type as modulus or roundrobin..
try this...

Is This Answer Correct ?

1 Yes

3 No

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 ..

Answer / varaprasad

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

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 ..

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

Post New Answer

More Data Stage Interview Questions

What are data elements?

0 Answers

what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

1 Answers Wipro,

i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?

2 Answers Wipro,

How to create a doccument in datastage?

1 Answers Cap Gemini,

How to reverse the string using unix?

0 Answers CTS,

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers

eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000

2 Answers HCL,

i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer

2 Answers

What are the types of hashed files in data stage

0 Answers

How do you schedule or monitoring the job?

0 Answers

What is the use of hoursfromtime() function in transformer stage in datastage?

0 Answers

Differentiate between operational datastage (ods) and data warehouse?

0 Answers

For more Data Stage Interview Questions Click Here