what are objects in data warehouse?
Answers were Sorted based on User's Feedback
Answer / niranjana
Datawarehouse objects are Dimension tables,Fact tables,Unique identifiers and relationships
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / manju
Sources, Targets, Mappings, Mapplets, sessions, workflows,
worklets, tables, views, sequences,procedures, cursors... are
objects part of data warehouse.
| Is This Answer Correct ? | 3 Yes | 6 No |
How mapping parameter and variable works
how many session run unix environment what command using ?
What is a filter transformation and why it is an active one?
why do u use shortcuts in informatica.?
i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,
What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
How will you combine 3 different sources with a single source?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
What are the performance considerations when working with aggregator transformation?