Explain about cumulative Sum or moving sum?
No Answer is Posted For this Question
Be the First to Post Answer
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?
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)
What are the different types of code pages available in informatica & how to implement it in your project?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
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
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?
How to generate or load values in to the target table based on a column value using informatica etl tool.
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.
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??
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