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
- 15208 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
Explain the tuning lookup transformation - informatica
Briefly describe lookup transformation?
What are active transformations.
What is olap (on-line analytical processing?
Mention some types of transformation?
Is stop and abort are same in informatica?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is a filter transformation?
What is difference between a gateway node and worker node?
What all join we can perform in LOOKUP transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
what is unit testing?tell me proceedure
What is dynamic cache?
What is pmcmd command?
