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 |
Define enterprise data warehousing?
What are the tasks that can be performed using sq?
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
if i have a delimited file as source so how can we seperate this file into three diff targets?
How to display null values on a target & non-null values on a target?
can every transfomation reusable?how?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
Why touse stored procedure in ETL Application?
Whatis the difference between View and Materialized View ?
If we are using an aggregator but forget to mention the group by port .what will be the output??