Interested to Buy Any Domain ? << Click Here >> for more details...
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
- 5 Answers
- 11734 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / radhakrishan
Use the cume function in salary port in expression transformation. It will give the cumulative values in target.
for reference
https://community.informatica.com/solutions/calculate_move_sum_avg
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / kriishh
take SQ->EXP.In expression create a variable port
V_CUM_SAL=V_CUM_SAL+SAL
then create a new o/p port o_sal=V_CUM_SAL
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / abhinaw prakash
You can make use of Variable ports for storing values
coming as input.For output you can compare values and give
the output.
the expression for output will look something like
IIF(Input_sal=v_prev_sal,v_prev_sal,input_sal+v_prev_sal)
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / jayachandra
use expression transformation here take two variable ports
one varaible port as v_sal and one more variable port as
o_sal and assign as o_sal=o_sal+sal
and write condition csum as
iif(sal=v_sal,o_sal+sal,o_sal)
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / sameer
First we uses cumulative function and second we can use expression transformation then we can calculate
| Is This Answer Correct ? | 0 Yes | 0 No |
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com
how to insert header after each group.
What are the Differences between connected and unconnected lookup?
What is a sequence generator transformation?
Filter transformation in the condition one of the data is NULL would the record be dropped.
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How to start a workflow using pmcmd command?
why do we go for update strategy tr in SCD rather using the session properties?
How do you take care of security using a repository manager
Teradata 
