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
- 15034 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
How can repository reports be accessed without sql or other transformations?
What is the meaning of decode in informatica?
What is the maplet?
update strategy transformation in informatica
list out all the transformations which use cache?
What is meant by a domain?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What do you understand by SOA of Informatica?
State the differences between sql override and lookup override?
What is the scenario which compels informatica server to reject files?
Write the program through which the records can be updated?
How can we create index after completion of load process?
How can a transformation be made reusable?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
is it possible to index the data in cache of lkp transformation ?
