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

Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 Answers

I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know

6 Answers

Highlight the main features of datastage?

0 Answers

what are the errors,warnings in datastage

0 Answers Syntel, Wipro,

source contains 2 columns comes to target 4 columns how

1 Answers IBM,

If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically

6 Answers TCS,

AGGREGATOR default datatype

0 Answers CTS,

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

2 Answers Infosys,

in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?

2 Answers Wipro,

In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.

2 Answers IBM,

Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers Accenture,

Explain the ChangeApply stage?

11 Answers

For more Data Stage Interview Questions Click Here