What is mapping debugger?
No Answer is Posted For this Question
Be the First to Post Answer
What is a node in Informatica?
What are the tuning techniques you applied during your last project
What is native users?
what is dynamic cashe
without table how to come first record only in oracle?
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
what is procedure to use mapping variable in source qualifier transformation? with example
scenario
How would you copy the content of one repository to another repository?
How to improve the session performance in informatica?
If a table contains 100 records we have to fetch 50-100 records from source to target?how