Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 9 Answers
- 16159 Views
- I also Faced
- E-Mail Answers
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
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How to go to the older version for a mapping?
What are the limitations of joiner transformation?
Can you use flat files in Mapplets.
What are the various types of transformation?
How can you define user defied event?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Explain the difference between a data warehouse and a data mart?
Difference between Target-based loading and constraint-based loading?
What are the issues you have faced in your project? How did you overcome those issues?
How will the document be delivered to me?
How to create a non-reusable instance of reusable transformations?
Have you worked with/created Parameter file
What is persistent lookup cache?
Under what condition selecting sorted input in aggregator may fail the session?
