When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
Answer Posted / sandy
Connected Lookup :- When we require more than one row to be
output from the lookup.
UnConnected Lookup:- When we need only one port as output
from the lookup
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Is stop and abort are same in informatica?
can we override a native sql query within informatica? Where do we do it?
Name the different lookup cache(s)?
What do you mean by channel change?
How do you load first and last records into target table?
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?
Parameter and variable differences
what is $$$$?
How might one distinguish in the case of mapping is right or not without associating session?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are the different types of olap? Give an example?
Why update strategy and union transformations are active? Explain with examples.
What is dimensional table?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is the scenario which compels informatica server to reject files?