What is the difference between Connected and UnConnected
Lookup Transformation.Give me one or two examples please?
Answer Posted / srinu
conn LKP Trans CACHE Reusable with Persistent caache
option.
Conn lkp supports Default value.
---------
UNCONN LKP Trans CACHE not reusable.
UNCONN LKP Trans Not support Default value.
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Clarify the aggregator change?
Informatica settings are available in which file?
How does a sorter cache works?
What is a pre-defined event and user-defined event?
What are pre and post-session shell commands?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Write the unconnected lookup syntax?
How many number of sessions can one group in batches?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Please let me know how to make Data masking in informatica..
How do you set a varible in incremental aggregation
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?