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
difference between informatica 8.1.1 and 8.6
What does cheating measurement mean?
What is an active transformation?
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 is the use of source qualifier?
What does reusable transformation mean?
What are the advantages of informatica?
What is a filter transformation?
What are the differences between joiner transformation and source qualifier transformation?
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
What are the new features of informatica 9.x in developer level?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
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.
What is persistent lookup cache?
What is primary and backup node?