What are the types of lookup transformation?
What is a dimensional model?
how to run the batch using pmcmd command
How to generate the HTML output using Informatica.
what happens when a batch fails?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain the pipeline partition with real time example?
Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
What are the new features of informatica 9.x developer?
how to load rows into fact table in data warehouse
What is decode in static cache?
what is parallel querying and what r hints.
guys which is the best institute in banglore to learn informatica??