In which conditions we can not use joiner transformation
(Limitaions of joiner transformation) ?
- 2 Answers
- 9765 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 |
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Explain dynamic target flat file name generation in informatica
is it possible to index the data in cache of lkp transformation ?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is a candidate key?
When you move from devel to prod how will you retain a variable
how DTM buffer size and buffer block size are related
What are the phases in SDLC?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
What's the layout of parameter file (what does a parameter file contain?)?
Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)
Which transformation is needed while using the Cobol sources as source definitions?
Teradata 
