How will restrict values in 0-9 and A-Z and a-z and special
character.Only allowed these chars otherwise we will reject
the records? what is the function we used to restrict...

Answer Posted / abhishek

REGEXP_LIKE(COL_NAME,'[[:alphanum:]]')

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain in detail about scd type 1 through mapping.

582


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1511


How to Create a folder using pmrep command?

618


Global and Local shortcuts. Advantages.

1462


What is sequence generator transformation in informatica?

616






Did u used latest transformations of 8.6.0? for what?

1473


What is Session and Batches?

658


Briefly define a session task?

588


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1614


What is the maplet?

616


What is the surrogate key?

629


can anyone suggest best free Talend data integration training online

1253


expain about the tune parameters?

1877


Differentiate between joiner and lookup transformation?

608


where to store informatica rejected data? How to extract the informatica rejected data?

597