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
- 6053 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 |
insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files
How you prepared reports for OLAP?
how can we check whether a particular cache is static or dynamic?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
why union transformation is active transformation?
waht is dataware house
Differences between connected and unconnected lookup?
What is confirmed dimension with scenario
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
Teradata 
