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
- 15720 Views
- I also Faced
- E-Mail Answers
Answer Posted / santosh sinha
This is really a confusing question and raise question on
OLTP design butIf we are not changing the design of column
which is used in our mapping then it will not effect the
mapping so increasing the no of column will not effect.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the fact table?
What is pmcmd command?
How you know when to use a static cache and dynamic cache in lookup transformation?
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.
I have a flat file, want to reverse the contents of the flat file
Implementation methodology
tell me about your project functionality
Repository user profiles
What is different between the data warehouse and data mart?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain the scenario which compels informatica server to reject files?
can u any challenge your project?
what are 3 tech challenges/ common issues you face?
What do you understand by term role-playing dimension?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
