i want to convert below src into target
src is as follows
maths 30
science 20
social 81
i want data in trg like below
maths science social
30 20 81
- 2 Answers
- 7020 Views
- HCL, HP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vikram
You need to use
SQ> Agg > TGT
>>> In AGG Ports>>>
Subject
Marks
O_maths = max(marks, subject='maths')
0_science = max (marks, subject ='science')
O_Social= max (marks,subject='social')
>>>>TGT
O_maths -> Maths
O_Scie -> Science
O_Social -> Social
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / amedela chandra sekhar
Use Normalizer t/r, it convert column into rows,row into
columns.
| Is This Answer Correct ? | 2 Yes | 11 No |
can we use bulk loading when we use look in mapping
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?
What is Code Page Compatibility?
replace multiple spaces with single space.
In joiner, how to load Master table in Target?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
when informatica 8 series released ?
what is the command to get the list of files in a directory in unix?
What is resilience time?
How do you use reject loader.
How can yoU create or import flat file definition in to the warehouse designer?
Teradata 
