1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

in my source table one of column contains the data like
vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these
records i need to send in target table as below format.
vishnuraju,suresh,krishna

Question Posted / keshava

Answer Posted / keshava

Using SQL

SELECT 'vishnraju@gmail', INSTR('vishnraju@gmail', '@'),
SUBSTR('vishnraju@gmail', 1, INSTR('vishnraju@gmail', '@')-
1) FROM DUAL

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Enlist the tasks for which source qualifier transformation is used.

582

difference between informatica 8.1.1 and 8.6

3236

Enterprise data warehouse your projects phase by phase explain?

1450

What are the data movement modes in informatica?

693

what are the Methods For Creating Reusable Transformations?

643




How do we call shell scripts from informatica?

588

What is pmcmd command?

668

Enlist some properties of sessions.

613

Explain the scenario which compels informatica server to reject files?

650

What are the popular informatica products?

646

Target increases every day even though no new record was inserted

1102

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

594

Mention few power centre client applications with their basic purpose?

528

How can we remove the duplicates from flat file source?

571

How we can use union transformation?

605