What is Collect performance data in informatica and what is the use of it.
Answer / rahul
Collect performance data this option is available at session level. used to identify the flow of records between transformations.
http://netezzamigration.blogspot.com/2014/10/what-is-collect-performance-data-in.html
Is This Answer Correct ? | 4 Yes | 1 No |
what is the diff b/w cached and unchaed look ups
To import the flat file definition into the designer where should the flat file be placed?
What are the Differences between connected and unconnected lookup?
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,
Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.
Without using any transformations how u can load the data into target?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Can we create a Integration service without a Repository service and vice versa?
how do u tune queries?
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
How can we update a record in the target table without using update strategy?
how many data models u have done in informatica project?