source table have single column single record having with
single space.
load that source record into trg . trgt having two columns
and the
SOURCE TABLE LIKE
COL1
BHANU PRASAD
TRGT TABLE
COL1 COL2
IN THAT LOAD THE RECORD IN THE trgt table LIKE
COL1 COL2
BHANU PRASAD
HOW ? TELL ME PLZ
Answer Posted / suraj kedia
Let our source table name is "Name",which is having COL1 and
data in it is BHANU PRASAD (For easier understanding instead
of space between bhanu and prasad,lets take a underscore
i.e. BHANU_PRASAD.
Source ----> Exp t/r ----> target
In the exp t/r take "name" as an input port only and create
2 out put ports as COL1 and COL2.
In COL1 give condition
substr(Name,1,instr(Name,'_',1)-1)
In COL2 give condition
substr(Name,instr(Name,'_',1)+1)
now connect COL1 port form exp to COL1 port in tgt and same
for COL2, than the out put in the target table will be as below:
COL1 COL2
BHANU PRASAD
Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is a pre-defined event and user-defined event?
What is parallel processing in informatica?
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?
Define joiner transformation?
Which files are created during the session rums by informatics server?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What are the modules in Power Center
COM components can be used in Informatica
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is the way to execute pl/sql script using informatica mapping?
What is the different lookup cache(s)?
How to generate sequence numbers without using the sequence generator transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
In which transformation you cannot drag ports into it?