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
- 11810 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 |
hw cn v elimate dublicate values from lookup without overriding sql?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How does the server recognize the source and target databases. Elaborate on this.
Can we change Dynamic to Static or Persistent cache? If so what happens?
two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .
Can i create a lookup table without cache.
What is the difference between view and materialised view?
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What are the types of metadata that stores in repository?
Can any body tell about the (UTC) unit test cases with the examples in informatica.
What are the circumstances that infromatica server results an unreciverable session?
Teradata 
