GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 245 of 327    Print  
How to perform cummulative sum in Mapping
For eg,
Id Amt
1 10
2 20
3 30
The output should be
Id Amt
1 10
2 30
3 60

  
Total Answers and Comments: 1 Last Update: December 08, 2007     Asked by: Irshad 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
December 08, 2007 07:50:40   #1  
rajkumarger Member Since: October 2007   Contribution: 1    

RE: How to perform cummulative sum in Mapping For eg,Id Amt1 102 203 30The output should beId Amt1 102 303 60
use CUME(Amt) function
 
Is this answer useful? Yes | No

 Related Questions

Latest Answer : Dimension Mapping: The mapping which uses target as one of the dimension is called dimension mapping, suppose a warehouse has 4dimension tables and 1 fact table that is a star schema of 4 dimensions we design 4 dimension mappings to load data into 4 dimensions ...

In lookup which one is better one connected and unconnected lookup?performance wise i am asking?if i am using five connected lookup in mapping that time what happens?
Read Answers (9) | Asked by : reddy

1) what is the difference between power center and power mart?2) diff b/w versions of Informatica 5, 6 an d7?3) what is ODS?4) how to give mapping & session parameter in file?
Read Answers (5) | Asked by : pratyusha

What is the main difference between mapping and mapplet designer in etl informatica and what transformations are used in the both?

I am asked to create a detailed metadata about ,transformations used in perticular fact table mapping.How do i understand and create write up on what has happened to each port during each tranformations?By right click on port in target definition and choosing backward path , I could get complete path fot that port.Pls. adviseThanks,
Read Answers (1) | Asked by : Adi
Tags : Metadata

Can anyone tell me , How to understand the use of transformations in informatica mapping for particular target port?
Read Answers (9) | Asked by : Adi

In Source 1 to 100 numbers? How can we load the even number in One target and odd number in another target?explain the mapping?How can we draw and wich transformations we r using?and explain logic?
Read Answers (6) | Asked by : Reddy

When i was running workflow manager i.e, when i right click the task icon and clicking start workflow from task, i am getting a message like 'cannot connect to the server'. Can any body guide me, how to get the output.Thanks
Read Answers (4) | Asked by : bn

Latest Answer : Hi,Export your mapping to XML file and then Import it to Client machine .  I am assuming here the client and your system as same version and environment for Informatica.-Sphurti. ...
Read Answers (1) | Asked by : uday

I want to send the excle sheet as a souce to another excel sheet as target.so i created a mapping with souce excel sheet to target sexcel sheet correctly. but i'm faling to enter the correct connection string in establishing relatonal connections for type ODBC .My ODBC data source is XL(Microsoft Excel Driver(*.xls)). tell me what is the connection string for ODBC (Like oracle is the conn string for Oracle services)
Read Answers (1) | Asked by : sasha


 Sponsored Links

 
Related Articles

EDI Mapping and Translation

EDI Mapping and Translation Mapping is a movement of information basically of putting the format of one data document onto another For instance it takes the format of an otherwise incompatible data format and makes it into an EDI compatible data document or conversely takes an EDI document and makes
 

C++ Standard Input Output Stream

C Standard Input Output Stream In this C tutorial you will learn about standard input stream and standard output stream explained along with syntax and examples C programming language uses the concept of streams to perform input and output operations using the keyboard and to display information on
 

What is Data Mapping

Data mapping is a very important aspect in data integration. In fact, it is the first step in the many complex tasks associated with data integration which include data transformation or data mediation between a data source and its destination; identification of relationships in data which is vital
 

How To Perform Class Loading With Java

How To Perform Class Loading With Java The class loading system for Java is both flexible and strong It will allow your programs to gains access to class databases without having to link to include" files which are static It will load archive files which contain these classes and other to
 

C Programming - Managing Input and Output Operations

C Programming Managing Input and Output Operations In this tutorial you will learn about Single character input output String input and output Formatted Input For Scanf Input specifications for real number Input specifications for a character Printing One Line Conversion Strings and Specifiers Speci
 

SQL Server 2000: Creating Stored Procedure with Input and Output Parameters

This tutorial explains how to create and use Stored Procedures with Input Parameters and output parameters along with the screen shots and sample code Creating Stored Procedure with Input Parameters mosgoogle Input Parameters in Stored Procedures are placeholders for data that the user needs to send
 

Be Prepared for Tech Job Cuts

Even one of the most flourishing and possibly the strongest industries of the future are not experiencing the economic crunch. The tech industry is now experiencing massive job losses in different categories. Although you will still see innovations almost every day from the tech industry through th
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape