Answer Posted / bhavani

we can acheive this using transformer stage:
1. Check the record count using AGGREGTOR stage and have a column count
2. In the transformer initiate a loop with condition @ITERATION <=count. and loopvar = @iteration
3.if @INROWNUM = loopvar then right(left(@iteration),1) --> output value

Now the result will be 2
5
6

Let me know if this is correct.

What is staging variable?

1153

---

How many types of hash files are there?

1234

---

Why fact table is in normal form?

1313

---

How to RD using transformer?

1480

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3524

---

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2548

---

Differentiate between datastage and datastage tx?

1115

---

What is apt_config in datastage?

1197

---

Can you explain kafka connector?

1380

---

How many types of sorting methods are available in datastage?

1116

---

Where do you see different stages in the designer?

1146

---

CHANGE CAPTURE

1354

---

What is the flow of loading data into fact & dimensional tables?

1113

---

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2444

---

What are the steps needed to create a simple basic datastage job?

1308

---