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
- 15959 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
Explain sessions. Explain how batches are used to combine executions?
Parameter and variable differences
Which transformation is needed while using the Cobol sources as source definitions?
How to load last n records of file into target table - informatica
What are the restrictions of union transformation?
What is blocking transformation?
What are the types of data warehouses?
what is $$$$?
Informatica Checkpoints
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is informatica worklet?
What is mapplet in informatica?
How many transformations can be used in mapplets.
How to extract the informatica rejected data?
How do you migrate data from one environment to another?
