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
- 9118 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
Do you find any difficulty while working with flat files as source and target?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Why do you use Mapping Parameter and mapping variable?
How can we delete duplicate rows from flat files?
What are the static cache and dynamic cache in informatica?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
how we can load rejected record's at run time?(not through bad files)
What is the benefit of partitioning a session?
What is the use of an aggregator cache file?
Explain in detail scd type 2 through mapping.
What is informatica?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Define update strategy?
What is workflow? What are the components of the workflow manager?
Enlist the differences between database and data warehouse.
