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
- 7835 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 your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
if i am having 10 records in source, i want 20 records in target...how will you do it
Different qualification between a related rotate toward the sky and isolates look upward?
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
Can you use one mapping to populate two tables in different schemas
What is power play plug in?
Can you copy the batches?
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
Teradata 
