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
- 15939 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
Difference between Data and Index Caches?
Explain transaction control transformation in informatica
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is the use of target designer?
Which is the t/r that builts only single cache memory?
design of staging area?
What do you mean by blocking transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is different between the data warehouse and data mart?
What is DR strategy for Informatica project?
Please let me know how to make Data masking in informatica..
What is flashback table ? Advance thanks
What is decode in informatica?
can u give example for factless fact table
