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 different transaction levels available in transaction control transformation?
What is a standalone command task?
Explain in detail about scd type 1 through mapping.
How do you load alternate records into different tables through mapping flow?
What is decode in informatica?
What is the difference between informatica 7.0 and 8.0?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Can you use flat files in Mapplets.
Explain lookup transformation is active in informatica
How to load the data from a flat file into the target where the source flat file name changes daily?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Write the unconnected lookup syntax and how to return more than one column.
Describe an informatica powercenter?
What is repository manager?
Explain in detail scd type 2 through mapping.