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
- 9064 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / krishna
select substr(cname,1,instr(cname,'@')-1) from table name
| Is This Answer Correct ? | 19 Yes | 3 No |
Post New Answer View All Answers
Explain lookup transformation is active in informatica
What is a shortcut and copy in Informatica and how two are different with each other?
What is incremental aggregation?
How an expression transformation differs from aggregator transformation?
Did u used latest transformations of 8.6.0? for what?
Explain incremental aggregation in informatica
What is decode in static cache?
During the running session, output files are created by informatica server. Enlist few of them.
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What do you mean by enterprise data warehousing?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How is union transformation utilized?
What do you mean by worklet?
