Explain about cumulative Sum or moving sum?
have u done any performance tuning? how u ll do?
explain about lookup t/r?
What is the Rankindex in Ranktransformation?
write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is aggregator transformation in informatica?
Which is costliest transformation? costly means occupying more memory?
I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.
Explain direct and indirect flat file loading (source file type) - informatica
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
what is degenerated dimension table with scenario