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, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
How to update a particular record in target with out running whole workflow?
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
Write the advantages of partitioning a session?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
what is target load plan
how can u load the data in time dimension?
How mapping parameter and variable works
What is flashback table ? Advance thanks
What happens if we dont select data driven option?