why cant we put a sequence generator or upd strategy
transformation before joiner transformation?

Answers were Sorted based on User's Feedback



why cant we put a sequence generator or upd strategy transformation before joiner transformation?..

Answer / srinivas

Joiner is to join two different sources .If u use Update
strategy T.F and trying to use DD_delete&DD_reject option
the some of the data will get deleted and u can't see the
at joiner output.
So we can't go for this .

Is This Answer Correct ?    5 Yes 7 No

why cant we put a sequence generator or upd strategy transformation before joiner transformation?..

Answer / bhupal

if you use the update strategy transformation before joiner in mapping, the mapping will be invalid because of data flow validation errors in mapping irrespective of operations you implemented in update strategy.

joiner transformation input should be from source qualifier transformation.

source---->sq--->seq--->
joiner---->trg
source---->sq---->

we cant create mapping like this because seq does't allows port to create and accept from other tr.

src--->sq--->
joiner--->trg
seq--->
we cant create like this. joiner inputs should be from source qualifier.

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Informatica Interview Questions

what is song in infrmatica...?

0 Answers   CTS,


Which transformation should u need while using the cobol sources as source defintions?

2 Answers  


What are the out put files that the informatica server creates during the session running?

2 Answers  


What is aggregator transformation in informatica?

0 Answers  


Explain the tuning lookup transformation - informatica

0 Answers   Informatica,






Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,


I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,


How many input parameters can exist in an unconnected lookup?

0 Answers  


What is expression transformation?

0 Answers  


how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,


In operator is used in which transformation in informatica 8.6.0

5 Answers   Virtusa,


i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

5 Answers   Cap Gemini,


Categories