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
- 13490 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 do you understand by SOA of Informatica?
How does a sorter cache works?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is xml source qualifier transformation in informatica?
Define mapping and session?
How can we improve session performance in aggregator transformation?
What are the informatica performance improvement tips
Why do we need informatica?
generate date / time dimension in informatica
Different sorts of metadata that stores in the storage facility?
What is target load order?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Enlist the advantages of informatica.
In informatics server which files are created during the session rums?
What is domain in terms of informatica?
