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

How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

2 Answers TCS,

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

0 Answers

how to configure databases through datastage

2 Answers

What are the features of datastage flow designer?

0 Answers

what is use of SDR function?

0 Answers CGI,

How a routine is called in datastage job?

0 Answers

What is the difference between Datastage 7.5 and 7.0?

0 Answers

I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3

2 Answers TCS,

Can you explain repository tables in datastage?

0 Answers

Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.

4 Answers Amdocs,

I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers TCS,

What is staging variable?

0 Answers

For more Data Stage Interview Questions Click Here