Using Connected or unconnected lookup for performance wise which one is preferable?.
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 |
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 Answers BirlaSoft, Genpact, L&T, Syntel,
How many joins in Informatica
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
how to join two flat files in informatica?
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
tell me the rules and responsblites in our project(my project is development)
how will compare two mappings in two different repository?
what is scd?
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
What is workflow monitor?
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
What is a joiner transformation?