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
While migrating the data from one environment to another environment how would you manage the connections?
Write the unconnected lookup syntax and how to return more than one column.
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What does reusable transformation mean?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is the advantage of informatica?
What is a router transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How are indexes created after completing the load process?
What is informatica?
What is the use of code page?
What does “tail –f” command do and what is its use as an Informatica admin.
What are the reusable transformations?
What is the difference between informatics 7x and 8x and what is latest version?