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
What will be the approach?
How to load data in informatica ?
have u done any performance tuning? how u ll do?
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
What is the term PIPELINE in informatica ?
What are the different caches used in informatica?
What is factless fact schema?
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is the difference between source qualifier transformations source filter to filter transformation?
What is olap (on-line analytical processing?
What is union transformation?