How will you check the bottle necks in informatica? From
where do you start checking?
Answers were Sorted based on User's Feedback
Answer / guest
you start as per this order
Target
source
mapping
session
system
Regards
Sukanta
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / sanat pandey
Source throught,
Target throught,
Informatica server Idle percentage (in last in session log)
Database (Source / Target)
Network idssue ..
Regards,
Sanat Pandey
Is This Answer Correct ? | 2 Yes | 0 No |
What is a joiner transformation?
can you please explain me pre session and post session options?
connected and unconnected lookups?
When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?
What are the data movement modes in informatica?
Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.
What is decode in informatica?
Label in Informatica. How to remove existing Label.
why union is active transformation?
How to load relational source into file target?
How do you take back up of repository?
How will you update the row without using update statergy?