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 |
In operator is used in which transformation in informatica 8.6.0
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
How can you recover the session in sequential batches?
Why do we use DSS database for OLAP tools?
Where do you create/define mapping parameter and mapping variable?
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me