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.
- 2 Answers
- 5942 Views
- IBM, I also Faced
- E-Mail Answers
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 partition the Session?
Explain what transformation and how many are there in informatica?
During the running session, output files are created by informatica server. Enlist few of them.
What is the use of target designer?
design of staging area?
How to load data in informatica ?
How to delete duplicate row using informatica?
How do you promote a non-reusable transformation to reusable transformation?
What is lookup change?
What is a passive transformation?
Differentiate between joiner and lookup transformation?
What you know about transaction control transformation?
What is the function of look up transformation?
which one is better performance wise joiner or look up
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
