Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 6404 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
 Code page compatibly –Where all changes are made to handle the scenario.
What are the prerequisite tasks to achieve the session partition?
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?
How many number of sessions can one group in batches?
Briefly define reusable transformation?
What is informatica worklet?
What do you mean incremental aggregation?
What does role playing dimension mean?
whether Sequence generater T/r uses Caches? then what type of Cache it is
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Teradata 
