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
How to do the error handling of if ur source is flatfiles?
Design a mapping to load a target table with the following values from the above source?
Does an informatica transformation support only aggregate expressions?
Explain sessions. Explain how batches are used to combine executions?
In informatics server which files are created during the session rums?
Enlist the advantages of informatica.
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is an expression transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are the types of schemas we have in data warehouse and what are the difference between them?
How to create Target definition for flat files?
what is song in infrmatica...?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Can we get 1st record through Informatica(without sequence number).