Answer / usha

by using dynamic lkp its possible...

in dynamic lkp if we r having 2 records..
i will inser 1st record and will update second record...

when ever data inserted in to the target cache get
refreshed..

we ttake dynamic lkp..
by defaul..new lkp row port is added...

we should enable the associatve port...

here we should give the condition ..


in router we should give condition as newlkp=1--it will
insert...

if newlkp=0 means duplicate recorts

Answer / p1khatri

using Dynamic lookup :-
for new record (i.e. Newlookuprow =1)insert into tgt 1
for duplicate records (i.e. Newlookuprow=0) insert into tgt
2

I hope this'll work

Answer / yaseen

sort the records with sorter t/r and with aggregator t/r give the group by and add 1 column give the expression as count(col)and in router t/r give condition as count=1 for unique and default for duplicate.

And I think for dynamic lookup newlookport = 0 then it is for no changes right like
0------no changes
1-------insert
2--------update

Plz correct me if I am wrong

Answer / sankar

by using router transformation

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,

---

What is Data Caches size?

0 Answers   Informatica,

---

Which transformation should we use to normalize the COBOL and relational sources?

4 Answers   DELL, IBM, Lehman Brothers,

---

What is junk dimention?

3 Answers   Patni,

---

What are the challenges of Dataware housing in the future?

2 Answers   HP,

---

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,

---

Enlist some properties of sessions.

0 Answers  

---

Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,

---

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

---

what is the process we used in joiner transformation,there is no matching column in sources?

2 Answers  

---

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,

---

In warehouses how many schemas are there?

0 Answers  

---