How will you check the bottle necks in informatica? From
where do you start checking?
Answer Posted / guest
you start as per this order
Target
source
mapping
session
system
Regards
Sukanta
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How do you load first and last records into target table?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
tell me 5 session failure in real time how can you solve that in your project?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Explain in detail scd type 2 through mapping.
How many dimensions are there in informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Briefly explain the aggregator transformation?
What are the components of Informatica? And what is the purpose of each?
What is the function of union transformation?
What are the differences between joiner transformation and source qualifier transformation?
What is a transaction control transformation?
What are multi-group transformations?
Explain the etl program with few examples.
What can we do to improve the performance of informatica aggregator transformation?