How can we create index after completion of load process?
No Answer is Posted For this Question
Be the First to Post Answer
can we use self join in informaitca?
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
which one is better performance wise joiner or look up
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
What are the new features of informatica 9.x developer?
What is an expression transformation in informatica?
Difference between task flow and linear task flow
Why filter transformation is an active one?
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
How to handle changing source file counts in a mapping?
guys which is the best institute in banglore to learn informatica??