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
- 10824 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 |
Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?
How to run a session, which contains mapplet?
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 Answers Cap Gemini, TCS, Wipro,
What are some examples of informatica etl programs?
What is event and what are the tasks related to it?
Explain dynamic target flat file name generation in informatica
how much memory (size) occupied by a session at runtime
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is a joiner transformation and why it is an active one?
if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
Teradata 
