Answer Posted / subh
In case multiple rows are expected in the joining
condition, joiner has to be used. As look up wont be able
to return multiple rows.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are active and passive transformations?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How do you load only null records into target? Explain through mapping flow.
How can informatica be used for an organization?
What does “tail –f” command do and what is its use as an Informatica admin.
As union transformation gives UNION ALL output, how you will get the UNION output?
what is Active lock explain
explain one complex mapping with logic? sales project?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain constraint based loading in informatica
What is meant by LDAP users?
What the difference is between a database, a data warehouse and a data mart?
What is an active transformation?
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.
