what is mapping performence?
Answers were Sorted based on User's Feedback
Answer / vino
Mapping performance is nothing but u tune the mapping to
achieve better performnace .
Like to use filter after sq,using sorter before
aggregator,deleting unwanted fields in the lookup etc.....
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / nafeeja
Mapping Performance is to tune the mapping for better performance. To achieve this first we need to find out the performance bottle necks at three levels and optmise those.
1) Identifying Source Bottlenecks
2) Target bottleneck.
3) Identifying Mapping Bottlenecks
Is This Answer Correct ? | 0 Yes | 0 No |
How can you join two tables without any common column present in them?
Which is the t/r that builts only single cache memory?
Explain the different lookup methods used in informatica?
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
What is the use of source qualifier?
what is casual dimension?
In Which scenario did u used Incremental loading?
Can u generate reports in Informatica?
Which kind of index is preferred in DWH?