Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7914 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 |
How to use Normalizer transformation?
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
what are the perameter and variable?
In Which scenario did u used Incremental loading?
What are the different options used to configure the sequential batches?
Under what condition selecting sorted input in aggregator may fail the session?
Explain what is informatica metadata and where is it stored?
What is checksum termnology in informatica? Where do you use it ?
3 Answers Chase, Cognizant, Deloitte,
Diffrence between 7.1,8.1 and 8.6
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
How informatica recognizes mapping?
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
Teradata 
