Answer Posted / sudhakar
BY USING MAPPINING VARIABLES,FIRST DEFINE THE VARIABLE
E.DATE AND NEXT COMPARE E.DATE,IF IT MATCHES THEN DATA
AUTOMATICALLY LOADED.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the types of schemas we have in data warehouse and what are the difference between them?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is the use of target designer?
Briefly explain the aggregator transformation?
What is the use of source qualifier?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Different circumstance which drives informatica server to expel records?
What does update strategy mean, and what are the different option of it?
Why union transformation is an active transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
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.
Explain sessions and how many types of sessions are there?
Under which circumstances, informatica server creates reject files?
What do you understand by a term domain?
How do you load first and last records into target table?