Answer / vennapusa

sed 's/' '//g ' sample

Answer / shar

sed 's/' '//g ' sample
Or
Other way:(just in case)

In Transformer we can use function : CompactWhiteSpace(%string%)
Through which we can remove spaces.

Answer / bharath

By using the following command you can remove blank lines from unix file:

$ sed 's/ *//g' sample

How to RD using transformer?

0 Answers   CTS,

---

Differentiate between hash file and sequential file?

0 Answers  

---

how many types of remove the duplicate records?

3 Answers   Caterpillar,

---

Describe stream connector?

0 Answers  

---

what is usage of datastage with materialized views

4 Answers   HP, TCS,

---

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,

---

when will you go for dataset and fileset?

2 Answers   Accenture,

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

0 Answers   Wipro,

---

Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

1 Answers   Alpharithm Technologies,

---

what is sparse lookup?

7 Answers   IBM,

---

How to initialize environment variables?

4 Answers   Infosys,

---

how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

2 Answers   Wipro,

---