Answer / murali udayagiri

Write a pre-process shell script by using the below 2nd
command and overwrite to another file, use overwritten file
as source for loading.

1)
$ cat multi_delimeter.txt
1,murali%100#10
2%krishna#200,20
3%sasi%232,10
1%murali%100,30
4,krish,200%20

2)
$ sed -e 's/,/|/g' -e 's/%/|/g' -e 's/#/|/g' multi_delimeter.txt
1|murali|100|10
2|krishna|200|20
3|sasi|232|10
1|murali|100|30
4|krish|200|20

Thanks,
Murali Udayagiri

Answer / zaheer

One more thing, its possible for a flat file when delimeters
are common or same for each and every record by mentioned in
flat file wizard. But just thing is there any other process
to do above first question

Could you explain what is enterprise data warehouse?

0 Answers  

---

how can we use sorter transformation in joins?

5 Answers   IBM,

---

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,

---

how to get flatfile containg 10 records half records one target another half another target

2 Answers  

---

what are 3 tech challenges/ common issues you face?

0 Answers   TCS,

---

---

What is hash partition?

1 Answers  

---

How can repository reports be accessed without sql or other transformations?

0 Answers  

---

Explain joiner transformation in informatica

0 Answers   Informatica,

---

what are the types of facts with Examples?

3 Answers  

---

difference between shortcut and reusable transformation?

2 Answers  

---

What is status code?

2 Answers  

---

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

4 Answers   Wipro,

---