Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of
run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
No Answer is Posted For this Question
Be the First to Post Answer
I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
What is the default join that source qualifier provides?
i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
What is the Rankindex in Ranktransformation?
What are the different versions of informatica?
what is Active lock explain
can u any challenge your project?
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
How does the aggregator transformation handle null values?
what is persistant cache in which situation we will use persistantcache
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task