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
- 8925 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
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Can informatica load heterogeneous targets from heterogeneous sources?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How to generate sequence numbers without using the sequence generator transformation?
What are connected or unconnected transformations?
How many types of sessions are there in informatica.please explain them?
generate date / time dimension in informatica
What is the status code in stored procedure transformation?
What is a transaction control transformation?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What are junk dimensions?
Enlist the tasks for which source qualifier transformation is used.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
