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
- 15651 Views
- I also Faced
- E-Mail Answers
Answer Posted / shrikant
Hello,
If I understand this question properly, it says that the
no. of "Source" columns are changing.
I do not agree with this scenario. Probably in
Datawarehousing, you won't find such a design. As far as
DWH is concerned, it takes the data from the OLTP systems &
after performing some operations (E-extract, T- transform)
it finally loads the data in some targets.
Here, as per the question, the question itself arises for
the OLTP design. No any OLTP (or database design principal)
system suggests a varying number of columns.
So, please do not get confused by such trivial kind of
questions. DWH is a very disciplined subject & it follows a
very good standards. Please go through the concepts first.
You will get a clear picture of DWH then.
| Is This Answer Correct ? | 18 Yes | 3 No |
Post New Answer View All Answers
Does an informatica transformation support only aggregate expressions?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Explain scd type 3 through mapping.
what is the Default Source Option For Update Strategy Transformation?
How do you update the records with or without using update strategy?
What is sequence generator transformation in informatica?
How to open an older version of an object in the workspace?
Why update strategy and union transformations are active? Explain with examples.
Enlist the differences between database and data warehouse.
Explain the mapping variable usage example in informatica
Explain what are the different versions of informatica?
What do you mean by enterprise data warehousing?
What is the use of source qualifier?
Mention some types of transformation?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
