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
Define pmcmd command?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What the difference is between a database, a data warehouse and a data mart?
How do you set a varible in incremental aggregation
what is the size of u r source(like file or table)?
Why union transformation is an active transformation?
Difference between Data and Index Caches?
What are the components of Informatica? And what is the purpose of each?
What is the procedure for creating independent data marts from informatica 7.1?
What is event and what are the tasks related to it?
Please let me know how to make encryption and decryption with example?
what are factless facts? And in which scenario will you use such kinds of fact tables.
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is a repository manager?
What are the different types of repositories created using informatica?