How can we create index after completion of load process?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

can we use self join in informaitca?

3 Answers   IBM,


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.........?

4 Answers  


which one is better performance wise joiner or look up

0 Answers   Informatica,


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.

2 Answers  


What are the new features of informatica 9.x developer?

0 Answers  






What is an expression transformation in informatica?

0 Answers  


Difference between task flow and linear task flow

0 Answers  


Why filter transformation is an active one?

0 Answers  


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

3 Answers   TCS,


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.?

3 Answers   IBM,


How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,


guys which is the best institute in banglore to learn informatica??

2 Answers  


Categories