Using @iteration=2 looping and define two stage variables and put the if el

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 / geetha

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

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

How many types of sorting methods are available in datastage?

1076

how to sort two columns in single job in datastage.

2907

How to RD using transformer?

1431

On which interface you will be working as a developer?

1052

CHANGE CAPTURE

1311

Notification Activity

1416

What is meta stage?

1188

Name the different types of Lookups in Datastage?

1264

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2295

How many areas for files does datastage have?

1156

How a routine is called in datastage job?

1122

How to read multiple files using a single datastage job if files have the same metadata?

1253

How to find value from a column in a dataset?

2208

Is the value of staging variable stored temporarily or permanently?

1004

What is the difference between informatica and datastage?

1235