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 / santosh sinha
This is really a confusing question and raise question on
OLTP design butIf we are not changing the design of column
which is used in our mapping then it will not effect the
mapping so increasing the no of column will not effect.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is mean by complex business rule ?
How can we store previous session logs?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is blocking transformation?
What is transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
can you please explain me pre session and post session options?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain the etl program with few examples.
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What differs when we choose the sorted input for aggregator transformation?
How to create Target definition for flat files?
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 is informatica etl tool?
explain about unit testing? in real time?