Interested to Buy Any Domain ? << Click Here >> for more details...
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...
- 6 Answers
- 12183 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rams
replacechr(0,reg_replace(input,'[^a-z A-Z]','/')'/',null)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is sq transformation?
What is domain in terms of informatica?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Is it possible to use a client with different version than that of its Informatica server?
How many numbers of sessions can one group in batches?
Explain scd type 3 through mapping.
What is data movement mode in Informatica and difference between them?
What is an unconnected transformation?
What do you understand by a term domain?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is informatica?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
