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
- 7270 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 |
write a query to retrieve the latest records from the table sorted by version(scd)
How to call stored Procedure from Workflow monitor in Informatica 7.1 version?
sample mappings for scd1,scd2 and scd3
i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
what is the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
How to delete the data in the target table after loaded.
what is persistant cache in which situation we will use persistantcache
What are the types of error logs available in Informatica?
why we need informatica
What are the steps involved in the migration from older version to newer version of Informatica Server?
can u any challenge your project?
Teradata 
