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
- 15600 Views
- I also Faced
- E-Mail Answers
Answer Posted / arnab
This should not happen when executing a datawarehousing
project , This reflects poor design and poor visualisation
of the requirements
The safest way to handle this is re-import the source
definition, someone suggested create a source with the
maxinmum number of columns , there is something called
quality of code and if someone codes like this it is really
a bad example of informatica coding
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the aggregator transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What the difference is between a database, a data warehouse and a data mart?
what are 3 tech challenges/ common issues you face?
Target increases every day even though no new record was inserted
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?
Explain joiner transformation in informatica
What do think which one is the better joiner or look up?
How to use procedural logic inside infromatica?
list out all the transformations which use cache?
How many transformations can be used in mapplets.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
