eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sb

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

Question Posted / chandrasekhar.dasg

2 Answers
8678 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 ..

Answer / venu

Use Pivot stage......

Is This Answer Correct ?

11 Yes

3 No

eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 ..

Answer / geetha

Using @iteration=2 looping and define two stage variables and put the if else condition to provide the derivation (ex: @iteration=1 then acct1 else if @iteration=2 then acct2.)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Data Stage Interview Questions

What is exact difference between Parallel Jobs and server Jobs..

8 Answers DELL, IBM,

what are the errors,warnings in datastage

1 Answers Syntel, Wipro,

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

0 Answers Wipro,

specify data stage strength?

1 Answers

it is possible to load two tables data into one sequential file?if possible how?plz share with me?

6 Answers TCS,

What modeling tool do you use?

6 Answers HP,

WHAT IS FORCE COMPILE?

3 Answers FIS, HCL, Polaris,

How you can fix the truncated data error in datastage?

1 Answers

What are the stages in datastage?