Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
No Answer is Posted For this Question
Be the First to Post Answer
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is informatica metadata and where is it stored?
how will you get 21 to 30 record from 50 records?
How are parameters defined in informatica?
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
how do u move the code from development to production?
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
What is the fact table?
Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks