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
- 8924 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
How to elaborate powercenter integration service?
what is diff b/t sorter t/r and agg have the option sorter property...
How can you define user defied event?
Difference between Target-based loading and constraint-based loading?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Can we override a native sql query within informatica?
What is rank transformation?
How to join three sources using joiner? Explain though mapping flow.
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are the different types of repositories created using informatica?
Which version configuration tool used in ur project?
How identifying bottlenecks in various components of informatica and resolving them?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Explain dynamic target flat file name generation in informatica
How do you remove duplicate records in informatica? And how many ways are there to do it?
