When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
Answer Posted / poluraju
u return multiple ports you can choose connected lookup.if u want to return only one port u can choose connected or unconnected lkp.but if we want to call the same lookup multiple time with different input for single row then we choose unconnected lkp...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain what transformation and how many are there in informatica?
Write the unconnected lookup syntax?
What does refresh system mean, and what are its distinctive choice?
To import the flat file definition into the designer where should the flat file be placed?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Mention a few design and development best practices for informatica?
What are the differences between joiner transformation and source qualifier transformation?
How do you convert single row from source into three rows into target?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How to differentiate between the active and passive transformations?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is the difference between informatics 7x and 8x and what is latest version?
How to handle decimal places while importing a flatfile into informatica?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
While migrating the data from one environment to another environment how would you manage the connections?