What is substr in informatica?
No Answer is Posted For this Question
Be the First to Post Answer
What does refresh system mean, and what are its distinctive choice?
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
what is the size of u r project? and what is the size of source file?
what is parameter file?
What are the different threads in DTM process?
Can you use flat files in Mapplets.
What is a command that used to run a batch?
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,
in oracle write query yourname+1 from dual
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks