hi guys
i have an question how do you find out weather the column is
numeric or combination of char and numbers or it contains
char,numeric and special characters.
Answer Posted / abhishek guddu
In Expression t/f
flag--
iif(is_number(id),to_integer(id),to_char(id))
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
In how many ways we can create ports?
what are 3 tech challenges/ common issues you face?
How to do unit testing in informatica? How to load data in informatica ?
What is meant by lookup transformation?
What are the different lookup cache(s)?
How to extract sap data using informatica?
How to create the source and target database connections in server manager?
Define mapplet?
How you know when to use a static cache and dynamic cache in lookup transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
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?
What are the differences between joiner transformation and source qualifier transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
tell me about your project functionality
Is it possible to define a single node as a Gateway node as well as worker node?