I Have 100 Records in a relational tble and i want to load
the record in 3 targets , first records goes to target 1
and second to target 2 and third to target 3 and so
on ,what are the tx used in this and what are the
logics ,can any one help me ?? Thanks in Advance
- 6 Answers
- 13772 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Post New Answer View All Answers
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
Where are the source flat files kept before running the session?
What is session task and command task?
How do you load unique records into one target table and duplicate records into a different target table?
What are Dimensional table?
During the running session, output files are created by informatica server. Enlist few of them.
Is stop and abort are same in informatica?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Enterprise data warehouse your projects phase by phase explain?
What is sorter transformation?
Explain how many types of dimensions are available in informatica?
what are the Methods For Creating Reusable Transformations?
What is confirmed fact in dataware housing?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Describe the impact of several join conditions and join order in a joiner transformation?
