Interested to Buy Any Domain ? << Click Here >> for more details...
i have f;latfile source. i have two targets t1,t2. i want to
load the odd no.of records into t1 and even no.of recordds
into t2.
- 3 Answers
- 7171 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / akash
By using Router Transformation
SQL Server : (id%2 = 0 or 1)
Oracle : mod(id,2) = 0 or 1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is rank transformation?
What is resilience time?
What is a node in Informatica?
What are the features of complex mapping?
What is dimensional table? Explain the different dimensions.
What are the static cache and dynamic cache in informatica?
Separate from an archive server and a powerhouse?
How identifying bottlenecks in various components of informatica and resolving them?
What is the fact table?
Briefly define a session task?
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
How we can create indexes after completing the load process?
how to load dimension table and fact table. plz tell me the steps.
Different qualification between a related rotate toward the sky and isolates look upward?
what is $$$$?
