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
- 7215 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 |
According to his methodology what all you need before you build a datawarehouse
How can repository reports be accessed without sql or other transformations?
can we see default group,when we use router?if yes how?
What are the disadvantages of Sequence Generator T/R?
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
can we load the data with out a primary key of a table? what is target plan?
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?
What are the different types of olap? Give an example?
Teradata 
