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

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?

1 Answers   Emphasis,

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers   IBM,

How do you handle two sessions in Informatica

0 Answers   Informatica,

How do you use reject loader.

0 Answers  

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,

what is the size of u r project? and what is the size of source file?

1 Answers   HP,

what is song in infrmatica...?

0 Answers   CTS,

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers   HCL,

how many data models u have done in informatica project?

2 Answers   TCS,

What are the main features of Oracle 8i with context to datawarehouse?

0 Answers  

How we can create indexes after completing the load process?

0 Answers