Interested to Buy Any Domain ? << Click Here >> for more details...
What are the associated ports in look up T/R.
- 5 Answers
- 25640 Views
- IBM, Zensar, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ravi
when we are using dynamic cache the associated port will be
enabled which is used to update or insert to the cache
| Is This Answer Correct ? | 23 Yes | 2 No |
Answer / 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 |
Answer / sivak
by using associated port we can generate sequence numbers
with out using sequence generator t/r.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / vicky yadav
when we are using dynamic cache the associated port will be
enabled which is used to update or insert to the cache.The
question is to update
cache columns we have to associate respective cache columns
to source input columns as associate port
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / achari
Using associate port in Dynamic lookup Transformation, we can do insert or update the cache in lookup.
| Is This Answer Correct ? | 1 Yes | 1 No |
Why we use lookup transformations?
explain about unit testing? in real time?
How you load distinct records into one target and duplicate records into another target?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is Micro Strategy? Why is it used for?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How do you handle two sessions in Informatica
What are the different types of repositories created using informatica?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com
Teradata 
