What are the types of maping wizards that r to be provided
in Informatica?
Answer Posted / swetha
The Designer provides two mapping wizards to help you create
mappings quickly and easily. Both wizards are designed to
create mappings for loading and maintaining star schemas, a
series of dimensions related to a central fact table.
Getting Started Wizard. Creates mappings to load static fact
and dimension tables, as well as slowly growing dimension
tables. Slowly Changing Dimensions Wizard.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What does command task mean?
What are the prerequisite tasks to achieve the session partition?
Define joiner transformation?
What is the command used to run a batch?
What is the difference between a connected look up and unconnected lookup?
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?
r u done any partitions in ur project?
What are the components of Informatica? And what is the purpose of each?
What are the restrictions of union 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.
What is the difference between router and filter?
can u any challenge your project?
What are the differences between joiner transformation and source qualifier transformation?
How do you handle two sessions in Informatica