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
- 10831 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 |
According to his methodology what all you need before you build a datawarehouse
While migrating the data from one environment to another environment how would you manage the connections?
What are the diffrences between joiner transformation and source qualifier transformation?
What are the challenges of Dataware housing in the future?
Define informatica repository?
What are Rapid changing dimensions?
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
How informatica process data means how informatica works?
What you know about transaction control transformation?
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
How can you access the remote source into your session?
Teradata 
