Hi,
source data is
col1 values are 5,6,7
col2 are 3,2,1
col3 are 8,9,10
and i want to get target as
col1 5,6,7
col2 1,2,3
col3 8,9,10
how to do this one?
Answer Posted / ram
use sort for col2
Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
Can you use flat files in Mapplets.
Explain what transformation and how many are there in informatica?
What is lookup change?
What is meant by query override?
Enlist the various types of transformations.
What is enterprise data warehousing?
What is sequence generator transformation in informatica?
which one is better performance wise joiner or look up
What is a predefined event?
Is it possible to define a single node as a Gateway node as well as worker node?
Why filter transformation is an active one?
What is option by which we can run all the sessions in a batch simultaneously?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Explain about cumulative Sum or moving sum?
complex mapping ur project u r invlve can u explain and give real time example give me ?