Answer Posted / subhash

SRC--->TFM--->PIVOT----> TGT

In TFM, use below logic
if col1<4 then 1 elseIf col1>3 AND col1<7 then 2 else 3-----
>col1
then out from TFM is:
col1,col2
1,1
1,rajesh
1,15000
2,2
2,suresh
2,16000
3,3
3,veeru
3,17000
In PIVOT, do vertical PIVOT, group by column is 'col1' and
pivot column is 'col2' then we will get desired output.

How to read the length of word in unix?

1311

---

Define Routines and their types?

1096

---

Name the different types of Lookups in Datastage?

1214

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

751

---

I have a few records just I want to store data in to targets cycling way how?

2301

---

What is the difference between account and directory options ?

1112

---

How do you generate sequence number in datastage?

1025

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3264

---

how to write server Routine coding?

2061

---

What are the types of views in datastage director?

1720

---

What is the project in datastage?

1046

---

What is usage analysis in datastage?

1262

---

What are the main differences you have observed between 7.x and 8.x version of datastage?

1023

---

Demonstrate experience in maintaining quality process standards?

2456

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1473

---