my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000
4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement
is like this id name sal up_sal,1 aa 1000 null,2 bb 2000
1000, 3 cc 3000 2000
4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on
so how can i get it plez reply for this as soon as possible
, thanks in advanced
Answer Posted / dev
Thanks a lot to both babu and moorthy for ur valuable time
for my doubt but i have another doubt is that as we are
assigning the port sal to prev_sal port how it holds the
previous sal as becz the currently it is holding the current
sal...... can u just explain me ...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain incremental aggregation in informatica
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
what are 3 tech challenges/ common issues you face?
I have a flat file, want to reverse the contents of the flat file
Repository user profiles
What is the difference between a repository server and a powerhouse?
How do you remove duplicate records in informatica? And how many ways are there to do it?
How can we use mapping variables in informatica?
How many ways are there to do 'remove duplicate records in informatica'?
what is degenerated dimension?
Differentiate between a repository server and a powerhouse?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Sequence generator, when you move from develoment to production how will you reset
Explain target update override in informatica
Explain sessions?