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
- 16160 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
Differences between version 7.x and 8.x.
What is deployment group?
Design time, run time. If you don't create parameter what will happen
What is a passive transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What you know about transaction control transformation?
Explain the shared cache and re-cache?
Have you worked with/created Parameter file
Difference between Target-based loading and constraint-based loading?
Mention some types of transformation?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is workflow monitor?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What are the new features of informatica 9.x developer?
