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
- 15645 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
Describe the impact of several join conditions and join order in a joiner transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
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
Under what condition selecting sorted input in aggregator may fail the session?
Explain constraint based loading in informatica
What is workflow? What are the components of the workflow manager?
What do you mean incremental aggregation?
Where is metadata stored?
Enlist the differences between database and data warehouse.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is the use of code page?
What are the types of presistent cache in look up tr.
What are the various types of transformation?
