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

Reusable transformation and shortcut differences

0 Answers  

---

What is expression transformation?

0 Answers  

---

How to load a relational source into file taget?

2 Answers  

---

following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

2 Answers   Patni,

---

Explain what transformation and how many are there in informatica?

0 Answers  

---

---

what is the size of your data warehousing?

0 Answers   IBM,

---

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

---

how do u tune queries?

1 Answers  

---

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,

---

tell me 7.x and 8.x diferrencess(but not transformations)

1 Answers  

---

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  

---