my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
Answer Posted / masudul
Just pass the rows through an expression transformation.
then add a new port and write down the expression code-
substr(column_name, 1, (instr(column_name,'@')-1)).
See the output.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How does a rank transform differ from aggregator transform functions max and min?
What is meant by a domain?
How can we create index after completion of load process?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Explain the scenario which compels informatica server to reject files?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain sql transformation in script mode examples in informatica
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?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How would you join a node to the already existing domain?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Explain sessions and how many types of sessions are there?
Can we get 1st record through Informatica(without sequence number).
Separate from a database, an information bazaar, and an information stockroom?