If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
2 6485If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
6 15814How 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 5266By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
1 6479On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
3 7227where does the default group roew in a router is stored what is the default size of memory in router
1 5076If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
2 6521Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
3 17795Post New Informatica Questions
Difference between Data and Index Caches?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How union transformation is used?
What is the commit type if you have a transaction control transformation in the mapping?
What is a standalone command task?
How can we use mapping variables in informatica?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is a shortcut and copy in Informatica and how two are different with each other?
How to call shell scripts from informatica?
What are junk dimensions?
How we can create indexes after completing the loan process?
What is lookup transformation?
Mention few advantages of router transformation over filter transformation.
How can you define user defied event?
can anyone suggest best free Talend data integration training online