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 5529If 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 13928How 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 4544By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
1 5714On 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 5916where does the default group roew in a router is stored what is the default size of memory in router
1 4166If 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 5529Suppose 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?
2 14389Post New Informatica Questions
How do you remove duplicate records in informatica? And how many ways are there to do it?
What are the measure objects?
What are the modules in Power Center
What is a joiner transformation and why it is an active one?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
how we can load rejected record's at run time?(not through bad files)
Differentiate between sessions and batches?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How do you migrate data from one environment to another?
How to elaborate powercenter integration service?
What is Cognos script editor?
If informatica has its scheduler why using third party scheduler?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.