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 would you copy the content of one repository to another repository?
What are the types of lookup transformation?
Explain in detail scd type 2 through mapping.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What do you understand by a term domain?
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
Explain the types of lookup transformation?
How are indexes created after completing the load process?
can we override a native sql query within informatica? Where do we do it?
How many number of sessions can one group in batches?
What do you mean by filter transformation?
What is the difference between Active and Passive transformation?
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.
What the difference is between a database, a data warehouse and a data mart?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?