Interested to Buy Any Domain ? << Click Here >> for more details...
If no. of source columns is changing every time (First time
it is 10 next time it is 20 so on). How to deal with it
without changing mapping?
- 9 Answers
- 15859 Views
- I also Faced
- E-Mail Answers
Answer Posted / bidhar
If this is the requirement,then you will have to reimport
the source metadata in source analyzer and the save so that
the new columns are reflected in the mapping source.But to
pull it to target you need to join manually the pipelines.
But Such type of scenarios rarelly comes in OLAP models.A
good DWH design should be in such a way that if in future
any new columns come in the OLTP systems then DWH can
accomodate that.
For example Product Table has 20 columns in OLTP system.
Then OLAP model can have more than 20 columns for Product
Dimension(ATRIBUTE_1,ATRIBUTE_2 and so on)and populate null
values into that.
Now whenever new columns are added into the OLTP Product
table then we can simply map the new column to the ATRIBUTE
Columns,Keeping the datatypes in mind.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we handle two sessions in informatica?
Describe expression transformation?
What is a passive transformation?
What is deployment group?
How you can differentiate between connected lookup and unconnected lookup?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is repository manager?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is mapping debugger?
Which version configuration tool used in ur project?
What is domain and gateway node?
What is lookup change?
what is INFORMATICA TESTING process
What is parallel processing in informatica?
Is there any target staging area in informatica not staging area
