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 are the limitations of joiner transformation?
In informatics server which files are created during the session rums?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
have u done any performance tuning? how u ll do?
What is workflow? What are the components of the workflow manager?
what is unit testing?tell me proceedure
What is workflow? What are the components of workflow manager?
What is domain and gateway node?
Explain the code page compatibility?
Why do we need informatica?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is the status code in stored procedure transformation?
What do you mean by blocking transformation?
What are the mapping parameters and mapping variables?
tell me the rules and responsblites in our project(my project is development)