Interested to Buy Any Domain ? << Click Here >> for more details...
In which conditions we can not use joiner transformation
(Limitaions of joiner transformation) ?
- 2 Answers
- 10788 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jaimeen shah
You cannot use a Joiner
transformation in the following situations:
♦ Either input pipeline contains an Update Strategy
transformation.
♦ You connect a Sequence Generator transformation directly
before the Joiner transformation.
Swetha is wrong because we can use joiner transformation,
we can join the sources from the same data source.
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / swetha
Both pipelines begin with the same original data source.
Both input pipelines originate from the same Source
Qualifier transformation.
Both input pipelines originate from the same Normalizer
transformation.
Both input pipelines originate from the same Joiner
transformation.
Either input pipelines contains an Update Strategy
transformation.
Either input pipelines contains a connected or unconnected
Sequence Generator transformation.
| Is This Answer Correct ? | 5 Yes | 6 No |
What is up date strategy and what are the options for update strategy?
Is informatica power center designer has 64 bit support?
Explain sessions?
what are the settiings that u use to cofigure the joiner transformation?
how will you remove the duplicate records from flat file without using sorter?
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
How to generate or load values in to the target table based on a column value using informatica etl tool.
Mention few power centre client applications with their basic purpose?
What differs when we choose the sorted input for aggregator transformation?
Explain the flow of data in Iinformatica?
Explain what are the different versions of informatica?
What is the difference b/w natural key and surrogate key
Teradata 
