Interested to Buy Any Domain ? << Click Here >> for more details...
supose if ur scr table contains alphanumeric values like
1,2,3,a,v,c in one columen like c1 n now u have load d data
in 2 seperare columns like ID should contain only numbers
1,2,3 n NAME col should contain a,b,cin target?How
- 4 Answers
- 14844 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / rajesh bathini
seq---> Transformer------>
in transformer take one stageVariable
stg==> Alpha(C1) after transformer take two outputlinks
take constrain stg=0 for one link (number will go that link)
otherwise for one link(alphabets will go that link)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a rank transform?
tell me the rules and responsblites in our project(my project is development)
Differences between connected and unconnected lookup?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How to call shell scripts from informatica?
Can anyone tell me the new features in Informatica 9 Version?
Under which circumstances, informatica server creates reject files?
can anyone suggest best free Talend data integration training online
Describe an informatica powercenter?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
what is the -ve test case in your project.
What is union transformation?
Explain Dataware house architecture .how data flow from intial to end?
Explain what is informatica metadata and where is it stored?
How to convert multiple rows to single row (multiple columns) in informatica
