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
waht type of interface is used for testing the data in informatica
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is the function of look up transformation?
Briefly describe lookup transformation?
What if the source is a flat-file?
How can you differentiate between powercenter and power map?
How can we delete duplicate rows from flat files?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Explain the different lookup methods used in informatica?
How would you copy the content of one repository to another repository?
How to call shell scripts from informatica?
What you know about transaction control transformation?
To import the flat file definition into the designer where should the flat file be placed?
difference between repository database and repository service?
What is aggregate cache in aggregator transformation?