In which conditions we can not use joiner transformation
(Limitaions of joiner transformation) ?
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 |
Explain lookup transformation is active in informatica
What is the Router transformation?
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
What is a repository manager?
ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
Can you copy the session to a different folder or repository?
Without source how to insert record to target?
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
if i have a delimited file as source so how can we seperate this file into three diff targets?
Please let me know how to make encryption and decryption with example?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate