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
- 15588 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
What is the way to execute pl/sql script using informatica mapping?
Enlist the differences between database and data warehouse.
What is the difference between writing a joiner query in ANSI style and THETA style?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How to configure mapping in informatica?
What is a surrogate key?
What is a node in Informatica?
Can informatica load heterogeneous targets from heterogeneous sources?
waht type of interface is used for testing the data in informatica
What are the different lookup cache(s)?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is a sorter transformation?
What is domain and gateway node?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
