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
Which transformation is needed while using the Cobol sources as source definitions?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How you can differentiate between connected lookup and unconnected lookup?
Mention few advantages of router transformation over filter transformation.
Can you generate sequence numbers without using the sequence generator transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How to do the error handling of if ur source is flatfiles?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are the advantages of informatica?
What is a filter transformation and why it is an active one?
What is Data Caches size?
What are the measure objects?
What is xml source qualifier transformation in informatica?
What is an expression transformation in informatica?
What is a sequence generator transformation?