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


Please Help Members By Posting Answers For Below Questions

if we have a delimiters at unwanted places in a flat file how can we over come those.

1565


In which transformation you cannot drag ports into it?

776


What is informatica powercenter repository?

709


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1629


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1330






Slowly changing dimensions, types and where will you use them

1266


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1845


What is a joiner transformation and why it is an active one?

575


Explain sql transformation in script mode examples in informatica

601


What is Cognos script editor?

3782


How can we use mapping variables in informatica?

597


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

597


Explain how many types of dimensions are available in informatica?

590


What is a difference between complete, stop and abort?

637


How can one identify whether mapping is correct or not without connecting session?

875