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.
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 a filter transformation and why it is an active one?
Is stop and abort are same in informatica?
What is target designer and target load order?
What is a joiner transformation and why it is an active one?
scenario where i can use only concurrent execution of workflow.
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
complex mapping ur project u r invlve can u explain and give real time example give me ?
generate date / time dimension in informatica
How are the sources and targets definitions imported in informatica designer?
What is sq transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
COM components can be used in Informatica
What are the main features of Oracle 8i with context to datawarehouse?
What can we do to improve the performance of informatica aggregator transformation?
What is a repository manager?