What are the types of maping wizards that r to be provided
in Informatica?
Answers were Sorted based on User's Feedback
Answer / nagarjuna
Two mapping wizards are there.
1. Simple pass through
2. slowly changing dimensions
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
What are partitions in informatica and which one is used for better performance?
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
What are the types of caches in lookup? Explain them.
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
what are cost based and rule based approaches and what is the difference?
what is the significance of newlookup port in dynamic look up
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
Could you explain what is enterprise data warehouse?
I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)