1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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.

Question Posted / jagadabhi.hima

Answers were Sorted based on User's Feedback



i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and..

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

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and..

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

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and..

Answer / usha

seq g
|
|
s-->sq--->RTR

in router netval=1
nextvale=2

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

What are the differences between oltp and olap?

0 Answers  

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers   HeadStrong, TCS,

How to extract sap data using informatica?

0 Answers  

scd methodology?

2 Answers  




How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?

4 Answers   IBM,

I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 Answers  

How many transformations can be used in mapplets.

0 Answers  

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  

If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers  

what is update strategy transformation ?

7 Answers   TCS,

What is diff joiner and lookup

4 Answers   BirlaSoft,

For more Informatica Interview Questions Click Here
Categories