What are the associated ports in look up T/R.
Answer Posted / g. sunil kumar
Associate port is used to associate lookup columns with
input source columns to update the cache. The main
advantage we use dynamic lookup is to synch target with
lookup (let me know if it wrong), to synch both target and
lookup we used to insert/update. The question is to update
cache columns we have to associate respective cache columns
to source input columns as associate port. Some times you
may have pk in target/cache, for that column assoicate a
Sequence_id, which generate (pkcolumn max value)+1 value
for each inserts. It wil not generate sequence value for
update, assume if we generate value for it also.. data will
not in order. Hope this clear !
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Differentiate between router and filter transformation?
Differences between version 7.x and 8.x.
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Explain load alternative records / rows into multiple targets - informatica
During the running session, output files are created by informatica server. Enlist few of them.
Different qualification between a related rotate toward the sky and isolates look upward?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is Cognos script editor?
What do you mean by enterprise data warehousing?
Please let me know how to make encryption and decryption with example?
Enlist the advantages of informatica.
What is informatica? Why do we need it?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is a transaction control transformation?
How do you load only null records into target?