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
- 13502 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
What is the difference between writing a joiner query in ANSI style and THETA style?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How can we use batches?
How do you load only null records into target? Explain through mapping flow.
How many number of sessions can one group in batches?
can we override a native sql query within informatica? Where do we do it?
What are the prerequisite tasks to achieve the session partition?
What is sorter transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
Mention a few design and development best practices for informatica?
What do you understand by term role-playing dimension?
Parameter and variable differences
What is the use of an aggregator cache file?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Explain what is informatica metadata and where is it stored?
