When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
Answer Posted / rohan
We can use unconnected lookup multiple times in the same
mapping if required.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the scenario which compels informatica server to reject files?
Explain the different kinds of facts.
Enlist the advantages of informatica.
How can we update a record in the target table without using update strategy?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How do you convert single row from source into three rows into target?
How to convert multiple rows to single row (multiple columns) in informatica
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is a surrogate key?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is a dimensional model?
How do you use reject loader.
How you prepared reports for OLAP?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is decode in static cache?