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 / 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


Please Help Members By Posting Answers For Below Questions

What is the difference between writing a joiner query in ANSI style and THETA style?

1917


What are the performance considerations when working with aggregator transformation?

674


Enlist the advantages of informatica.

628


 Informatica Checkpoints

2857


Global and Local shortcuts. Advantages.

1468






How can we store previous session logs?

567


Can we create a node as a gateway node and the same node can be assigned to a grid?

637


How to use pmcmd utility command?

580


What is the function of aggregator transformation?

575


Can we override a native sql query within informatica?

629


Does an informatica transformation support only aggregate expressions?

606


Can u generate reports in Informatica?

654


What is the difference between STOP and ABORT options in Workflow Monitor?

695


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

721


What is confirmed fact in dataware housing?

5681