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?
What are roles and groups and benefits of using them?
How can you join two tables without any common column present in them?
what are the limitations of pushdown optimization technique ? Advance thanks
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
What is data merging,data cleansing,sampling?
What are the uses of etl tools?
If informatica has its scheduler why using third party scheduler?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is a surrogate key?
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.