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.
Answers were Sorted based on User's Feedback
Answer / abpat2203
Add a sequence generator. Next, pass the all the data along
with that from the sequence generator into a router.
In the router, use the mod fucntion on the value incoming
from sequence generator.
If the mod fucntion returns a 0, pass it to T2 and if it
returns any other value other than 0, pass it into T1.
Is This Answer Correct ? | 14 Yes | 0 No |
Answer / 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 |
Answer / usha
seq g
|
|
s-->sq--->RTR
in router netval=1
nextvale=2
Is This Answer Correct ? | 0 Yes | 0 No |
What are the different types of Type2 dimension maping?
What is parameter file?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
What is the difference between Normal load and Bulk load?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
How many ways a relational source definition can be updated and what are they?
How are indexes created after completing the load process?
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
can we use mapplet as starting n ending object in mapping
if soource is having 10 records how will u insert 20 records to target
how will you remove the duplicate records from flat file without using sorter?
what is the monster dimension plz give me one example