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

Create source defination with maximum (depends on the max
numbers of columns u get in the source) number of fields
and use that in the mapping.
ex: create source defiantion with 20 fields and use this in
mapping this wil handle source comes with columns btween 1
to 20.

Note : Above wrks only for flat file sourcse not fr RDBMS
sources

Is This Answer Correct ?    0 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

difference between informatica 8.1.1 and 8.6

3456


What does cheating measurement mean?

798


What is an active transformation?

845


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 ?

1948


What is the use of source qualifier?

882


What does reusable transformation mean?

865


What are the advantages of informatica?

759


What is a filter transformation?

810


What are the differences between joiner transformation and source qualifier transformation?

891


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1922


What are the new features of informatica 9.x in developer level?

774


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1835


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.

1014


What is persistent lookup cache?

789


What is primary and backup node?

923