i have a flat file and the file s are like below
****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$
IN THIS FORMATE
Means un limited special charecter between and sides of the
string data..output should be(GANESH)
HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE
AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

Answer Posted / manasa

please put down the replace command for the above question

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does the aggregator transformation handle null values?

695


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1548


What is depict expression change?

612


How do you load first and last records into target table?

660


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1695






Design a mapping to load a target table with the following values from the above source?

870


Separate from an archive server and a powerhouse?

488


What are ETL Tools?

662


What is Session and Batches?

658


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1493


Define filter transformation?

619


Write the prerequisite tasks to achieve the session partition?

636


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1525


How do you convert single row from source into three rows into target?

599


What is meant by lookup transformation?

608