Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance
issue. how to fix the performnce issue of the query.
No Answer is Posted For this Question
Be the First to Post Answer
What is a router transformation?
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you
What is difference between Mapplet and reusable transformation?
What is the difference between unicode & ascii mode data movement in informatica?
Tell me about informatica architecture.
how can u load the data in time dimension?
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
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
On 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?
what happens when a batch fails?
How to configure mapping in informatica?