Answer / suresh

SQ ==> select rownum as num,col1,col2,.. from table
FLT ==> num >= MVar1 and num <=MVar2

Mvar1 and MVar2 are assigned with the value of 1 and 10 respectively

in EXP=>V-port - setvariable(mvar1, 10)
V-port - setvariable(mvar1, 20)

after the execution of the mapping 10 and 20 values are stored in the mvar1 and mvar2 into the repository

Answer / santosh

1. Create a mapping variable $$SESSION.
2. Link from SQ to Router t/r.
3. Create two group
a. SETMAXVARIABLE($$SESSION,$$SESSION+1) % 2 = 1
b. SETMAXVARIABLE($$SESSION,$$SESSION+1) % 2 = 0
4. Link both group to two filter and create two Sequence geneter and check the reset option.
5. Link the sequence generator to filter t/r.
6. Keep the condition as "NEXTVAL<=10" for first filter.
7. Keep the condition as "NEXTVAL>10" for second filter.
8. Link the two filter to two different target instance.

Let me know if any things wrong.

Thanks & Regards
Santosh Kumar Sarangi

Answer / babu

Hi,
If u r source is Relational,then u can write sqloverride.
i.e
SQ ==> select rownum as num,col1,col2,.. from table
FLT ==> (num >= MVar1 and num <=MVar2)

NOTE: MVar1,MVar2 are mapping variables the initial values
of these variables 1,10 with respectivelly.

after completion of firsst run the variables are increased
11,20 respectivelly.all are knows how to declare the
mapping variables.
IF THERE IS ANY WRONG PLEASE CORRECT ME.

Thanks,
Babu

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

---

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,

---

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,

---

what is workflow varible

1 Answers   HP,

---

Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

1 Answers   IBM,

---

---

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,

---

What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,

---

if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

9 Answers   BirlaSoft, Genpact, L&T, Syntel,

---

how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,

---

why sequence generator should not directly connected to joiner transformation ?

1 Answers   ANZ,

---

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

---

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  

---