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
- 9055 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / abhinaw prakash
1.Pass the coulmns to an expression transformation.
2.Create a variable port and use INSTR function to find the
location of @.
(INSTR(CNAME,'@')-1)
3.Create an output port and use SUBSTR function to extract
the substring from the string.
SUBSTR(CNAME,1,v_CNAME)
4.Pass it to the output port
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Clarify the utilization of aggregator cache record?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Explain the etl program with few examples.
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is the use of an aggregator cache file?
What are active transformations.
explain about unit testing? in real time?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Explian the Process of deployment groups in informatica
Did u used latest transformations of 8.6.0? for what?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
