Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6910 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
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How might you approve all mappings in the archive all the while?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How we can use union transformation?
What is an active transformation?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
what are the Methods For Creating Reusable Transformations?
What is xml source qualifier transformation in informatica?
Explain load alternative records / rows into multiple targets - informatica
How can informatica be used for an organization?
Can we create a Integration service without a Repository service and vice versa?
can anyone suggest best free Talend data integration training online
Explain informatica architecture - version 8 / 9
Different circumstance which drives informatica server to expel records?
