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
- 15926 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
How big was your fact table
What are multi-group transformations?
What does refresh system mean, and what are its distinctive choice?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How are the sources and targets definitions imported in informatica designer?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
can any one give some examples for pre sql and post sql(Except dropping and creating index).
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
how we can load rejected record's at run time?(not through bad files)
What is rank transform?
how to load rows into fact table in data warehouse
Why do we need informatica?
How do you set a varible in incremental aggregation
generate date / time dimension in informatica
What is parallel processing in informatica?
