Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9 Answers
- 11643 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
Hi,
If you are not sure about the id's sorting order
count = count+1
v_sal = IIF(count=1,null,v_prev_sal)
v_prev_sal = sal
out_sal = v_sal
http://deepinopensource.blogspot.com/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a dimensional model?
what is index?how it can work in informatica
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is rank transformation in informatica
Separate from a database, an information bazaar, and an information stockroom?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
how to load rows into fact table in data warehouse
What is complex mapping?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Explain target update override in informatica
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is option by which we can run all the sessions in a batch simultaneously?
How to load data in informatica ?
Difference between Target-based loading and constraint-based loading?
What is domain in terms of informatica?
