Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9268 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / abhinaw prakash
1.Pass the coulmns to an expression transformation.
2.Create a variable port and use INSTR function to find the
location of @.
(INSTR(CNAME,'@')-1)
3.Create an output port and use SUBSTR function to extract
the substring from the string.
SUBSTR(CNAME,1,v_CNAME)
4.Pass it to the output port
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is standalone command task?
What does command task mean?
Explain lookup transformation in informatica
What is the meaning of decode in informatica?
What are the designer tools for creating transformations?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
what is the hint? how to use it to reduce the query processing in program?
How might you approve all mappings in the archive all the while?
list out all the transformations which use cache?
What is workflow monitor?
Explain what transformation and how many are there in informatica?
Whats there in global repository
Enlist few areas or real-time situations where informatica is required.
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
