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
- 7178 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
wat are deployement groups in informatica, how it will be used for developers
Explain scd type 3 through mapping.
Whatis the difference between View and Materialized View ?
what is parameter file?
How to get EVEN & ODD numbers separately?
What is complex mapping?
what is diff b/t sorter t/r and agg have the option sorter property...
What did you do in source pre load stored procedure
Sequence generator, when you move from develoment to production how will you reset
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
Explain about perform recovery?
wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15
Teradata 
