what are the settiings that u use to cofigure the joiner
transformation?
Answers were Sorted based on User's Feedback
Answer / swetha
Master and detail source
Type of join
Condition of the join
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / raja
join condition
type of join
master and detail source
increase or decrease the cache sizes
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
What is dynamic cache?
What is a mapplet/worklet in informatica?
What is the difference between writing a joiner query in ANSI style and THETA style?
how to run the batch using pmcmd command
How to generate sequence numbers using expression transformation?
What are the join types in joiner transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
What if the source is a flat-file?
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000