Interested to Buy Any Domain ? << Click Here >> for more details...
SOURCE
NAME SAL
GANGA 30000
RAJU 20000
PAVAN 25000
TARGET
NAME SAL MAXSAL
GANGA 30000 30000
RAJU 20000 30000
PAVAN 25000 30000
in mapping level how to achive that
- 5 Answers
- 11070 Views
- DELL, I also Faced
- E-Mail Answers
Answer Posted / shekar
After source qulifier add a expression transformation in
the expression transformation create out put port name it
as maxsal then derive the code for this out put port as
setmaxvariable(sal).
Then pass the output ports from expression to target table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
can u any challenge your project?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Define filter transformation?
whats the logic to load the lower level of granularity of data to fact table.
How to load the data from a flat file into the target where the source flat file name changes daily?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
where to store informatica rejected data?
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 .
How identifying bottlenecks in various components of informatica and resolving them?
Explain about Informatica server process that how it works relates to mapping variables?
How to load last n records of file into target table - informatica
Explain what are the different types of transformation available in informatica.
How to elaborate tracing level?
