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
- 9269 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / sehaj
DO ONE THING....
CREATE AN EXTRA PORT FOR THAT.
IN THE EXPRESSION EDITOR,WRITE
REPLACESTR(0,cname,(SUBSTR(cname,INSTR(cname,'@'),INSTR(cname,'m',-1,1)),'')
PASS THIS PORT TO THE OUTPUT PORT......
SEHAJ-7204719446
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is target designer and target load order?
Explain lookup transformation is active in informatica
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Explain how to import oracle sequence into informatica?
How many ways a relational source definition can be updated and what are they?
Repository user profiles
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
How can you generate reports in informatica?
What is informatica? Why do we need it?
What is dimensional table?
Where do we use mapping variables in informatica?
What is the cumulative sum and moving sum?
