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?
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
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How to use pmcmd utility command?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Explain the different kinds of facts.
Which files are created during the session rums by informatics server?
How we can create indexes after completing the loan process?
What are the tasks that source qualifier perform?
how many types of dimensions are available in informatica?
How many input parameters can exist in an unconnected lookup?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
what is diff b/t sorter t/r and agg have the option sorter property...
What is decode in informatica?
What is depict expression change?
What is incremental aggregation?
What are the components of Informatica? And what is the purpose of each?