Answer / anu

sq->(seq)->exp->rtr->emp1(condition rowid <=100)
->emp2(condition rowid >100 and rowid<=200)
->emp3(condition rowid >200 and rowid<=300)
in exp t/r add new port and rename it as rowid and connect
to rtr.
note connect next val to rowid(in exp t/r).
in seq t/r change properties like
start value=1
increment by=1
last value=300
currval=1
cycle check it save it.

Answer / anu

take sequence generator connect neval port to router

in router create 3 groups

in 1st group (nextval<=100) or (nextval>300 and nextval<=400)
or (nextval>700 and nextval<=800)........trg1

in 2nd group (nextval>100 and nextval<=200) or (nextval>400
and nextval<=500) or (nextval>800 and nextval<=700)......trg2

in 3rd group (nextval>200 and nextval<=300) or (nextval>500
and nextval<=600) or (nextval>900 and nextval<=1000)......trg3

Answer / ramana sreepathi

Take sequence generator connect nextval port to router

in router create 2 groups

in 1st group (TRUNC(nextval, -2) mod 200 = 0) or (TRUNC
((nextval – 1), -2) mod 200 = 0) ..... trg2

in 2nd group (TRUNC(nextval, -3) mod 300 = 0) or (TRUNC
((nextval – 1), -3) mod 200 = 0) ... trg3

in default group
trg3

Answer / ajay konidena

1st answeris correct but for this logic we do use number
of ' or ' operater and code becom big so thire is on
solution that in sequence genarater t/f thire is one
option that cyclic as in oracle sql .
by using this option and router we can do this

Answer / anu

in above answer i given reverse conditions ..just modify conditions

but i think logic corrct

where to select code page option?

2 Answers   TCS,

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  

What is the difference between a table and the materialized view?

2 Answers  

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,

How to load relational source into file target?

3 Answers   IBM,

what are factless facts? And in which scenario will you use such kinds of fact tables.

0 Answers  

What are reusable transformations in how many ways we can create them?

2 Answers  

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

0 Answers  

Differentiate between reusable transformation and mapplet.

0 Answers  

in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

11 Answers   L&T,

in which situations do u go for snowflake schema ?

2 Answers   TCS,

What do you mean by blocking transformation?

0 Answers