my source contain data like this
cno cname sal
100 rama@gmail.com 1000
200 karuna@yahoo.com 2000
i want load my data to the target is
cno cname sal
100 rama 1000
200 karuna 2000
plz send the answer
- 5 Answers
- 7987 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / c
In the expression transformation use the following:
select cno,substr(cname,1,position('@' in cname)-1)as cname,sal from sample
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
can anyone explain me about retail domain project in informatica?
What is a predefined event?
What is a connected transformation?
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?
What is dimensional table? Explain the different dimensions.
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is primary and backup node?
how to create user defined function (udf) in informatica
Explain your project of banking domian.
What is an expression transformation in informatica?
have u done any performance tuning? how u ll do?
What is dimensional table?
Plz can any one say me how to get the informatica certification materials and dumps
Explain pmcmd command usage in informatica
Explain where to store informatica rejected data? How to extract the informatica rejected data?
