i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,

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

Question Posted / jhansi

2 Answers
7421 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target ..

Answer / hari chowdary

by using partition technique round rabin we can do easily.
single source table,two target tables

Is This Answer Correct ?

16 Yes

1 No

i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target ..

Answer / pranay

____tgt1
|
|
source------transformer---
|
|
-----tgt2

in transformer

TGT1 ---
constraint --> mod(deptno,2) = 1
source.deptno - deptno
source.sal - sal

TGT2 ---
constraint --> mod(deptno,2) = 0
derivation -->
source.deptno - deptno
source.sal - sal

u'll get the ans, if i'm wrong plz correct me

Is This Answer Correct ?

6 Yes

11 No

Post New Answer

More Data Stage Interview Questions

what is mapping lookup

1 Answers

What is datastage engine?

0 Answers

souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2

9 Answers

Different ways a project can be moved to production ?...example â€¦.export-import and Version control.

0 Answers

Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance

2 Answers IBM,

source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?

2 Answers Wipro,

How a source file is populated?

0 Answers

Difference between ‘validated ok’ and ‘compiled’ in data stage?

0 Answers

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

4 Answers UHG,

Name the different types of Lookups in Datastage?

0 Answers

how can u find out the datastage job is running on how many nodes

7 Answers IBM,

what is the difference between the join and look up explin me one exmple

3 Answers

For more Data Stage Interview Questions Click Here