Explain about cumulative Sum or moving sum?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?

1 Answers   TCS,


How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers   TCS, Tech Mahindra,


write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,


What are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,


write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

8 Answers   TCS,






How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

2 Answers   AHM,


we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,


Differentiate between router and filter transformation?

0 Answers  


How to generate or load values in to the target table based on a column value using informatica etl tool.

0 Answers   Informatica,


I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 Answers  


1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers   KPIT,


there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

3 Answers  


Categories