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
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 |
Tell me about informatica architecture.
What is joiner transformation in informatica?
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
How many ways are there to create ports?
How to load last n records of file into target table - informatica
What are the different components of powercenter?
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
why union transformation is active transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is meant by pre and post session shell command?
How to extract the informatica rejected data?
in a table it has 200 rows the query is select 150 from tablename.whats the output