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
- 15654 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
What is domain and gateway node?
How to use pmcmd utility command?
How to extract sap data using informatica? What is abap? What are idocs?
Implementation methodology
How can we create index after completion of load process?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Name the different lookup cache(s)?
what are factless facts? And in which scenario will you use such kinds of fact tables.
how to create user defined function (udf) in informatica
What are the issues you have faced in your project? How did you overcome those issues?
What is lookup change?
What is status code in informatica?
Why do we need informatica?
Define pmcmd command?
What could be the possible resons of locks by user?
