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 |
What are the uses of etl tools?
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,
How informatica recognizes mapping?
To provide support for Mainframes source data,which files r used as a COBOL files
What is confirmed fact in dataware housing?
what r the transformations that r not involved in mapplet?
In Which scenario did u used Incremental loading?
What is powercenter on grid?
Explain about Informatica server process that how it works relates to mapping variables?
write a query to retrieve the latest records from the table sorted by version(scd)
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
why do we go for update strategy tr in SCD rather using the session properties?