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 are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help
What are the types of maping wizards that r to be provided in Informatica?
how to work with mapplet designer in informatica?
Howmany ways yoU can update a relational source defintion and what are they?
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
How to load last n records of file into target table - informatica
What is pmcmd command?
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
how do u use sequence created in oracle in informatica? Explain with an simple example
How we can create indexes after completing the loan process?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?