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
State the limitations where we cannot use joiner in the mapping pipeline?
What is xml source qualifier transformation in informatica?
What is meant by query override?
What is data movement mode in Informatica and difference between them?
What is the surrogate key?
How to configure mapping in informatica?
permutations of mapplet
What are the uses of etl tools?
What are the types of data warehouses?
What is the use of code page?
Partition, what happens if the specified key range is shorter and longer
What is target designer and target load order?
Is it possible to define a single node as a Gateway node as well as worker node?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the types of lookup transformation?