Interested to Buy Any Domain ? << Click Here >> for more details...
Please let me know how we can implement the below scenario.
In a single mapping,more than 500 sources
(legacy,VSAM,relational) will be loading into only one
target. Whenever I retreive the data(any record) from
target, i need to find the details that the record belongs
to which source.
Thanks in advance..
- 5 Answers
- 12063 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / arnab
create a system where you can identify a source with an
ID.you may call it as datasource_num_id , build a cross
reference table to store all tis information , in the map
you can use this cross reference table to get the ID and
populate this id in ur target table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How to open an older version of an object in the workspace?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How can we update a record in the target table without using update strategy?
define galaxy repository in informatica
Can we get 1st record through Informatica(without sequence number).
If informatica has its scheduler why using third party scheduler?
Explain the shared cache and re-cache?
Explain the difference between mapping parameter and mapping variable?
What is data caches/ index caches?
What is meant by a domain?
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
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Explain informatica architecture - version 8 / 9
Differentiate between reusable transformation and mapplet.
