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

What is the session task and command task?

0 Answers  

---

what is polling?

1 Answers   Informatica,

---

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,

---

where actually the usage of push down optimization happens...

2 Answers  

---

how i will stop my workflow after 10 errors

2 Answers   HP,

---

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  

---

What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,

---

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 call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,

---

What is a configuration management?

1 Answers  

---

without using emailtask how will send a mail from informatica?

3 Answers  

---

Insert else update option in which situation we will use

4 Answers   HCL,

---