Using Connected or unconnected lookup for performance wise which one is preferable?.
- 1 Answers
- 1924 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer / sam
Performance wise unconnected lookup transformation is better as it returns one port & does not build dynamic cache. only static cache is build .
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
how can we run workflow with pmcmd?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Explain the types of transformations?
.prm wirh repalce .txt is possible?
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
when we dont use aggregator in mapping ?
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
What are the mapings that we use for slowly changing dimension table?
1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??
Teradata 
