How to calculate the cache size if say we are doing a
performance check on a mapping and found that a particular
cache needs to be changed. Is there a formula to calculate
this! i know that informatica has a auto option available
but how to calculate manually?
- 1 Answers
- 4950 Views
- I also Faced
- E-Mail Answers
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
What is the cumulative sum and moving sum?
Differentiate between a database and data warehouse?
connected and unconnected lookups?
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Briefly define reusable transformation?
Explain the scenario which compels informatica server to reject files?
Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
r u done any partitions in ur project?
How to load last n records of file into target table - informatica
Teradata 
