how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Answer Posted / vijaya
BY seeing the session log file we identify the source qualifier bottle necks in the mapping
if we find the bottle neck on source qualifier transformation change the properties in SQ
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
What is meant by lookup transformation?
What is the function of union transformation?
draw informatica architecture 8.6 ?
Define mapplet?
What is informatica? Why do we need it?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is option by which we can run all the sessions in a batch simultaneously?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How does the aggregator transformation handle null values?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Define update strategy?
What is the procedure for creating independent data marts from informatica 7.1?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the differences between source qualifier and joiner transformation?