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 |
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
What are connected or unconnected transformations?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How will u pas the data with out debugger?
what are the perameter and variable?
What are 2 modes of data movement in Informatica Server?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
How do you remove duplicate records in informatica? And how many ways are there to do it?
what is metadata?
in which situations do u go for starflake schema ?
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
1 lac of flat fles in source how to load target at a time?