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

WAT IS TEXT LOAD?

3 Answers   Wipro,

---

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,

---

What is target designer and target load order?

0 Answers  

---

Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.

1 Answers   Amdocs,

---

Make a note of the quantity vaults made in informatica?

0 Answers  

---

In ur current projectu have done any performance tuning of mappings?

1 Answers  

---

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,

---

tell me about your project functionality

0 Answers  

---

what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,

---

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

8 Answers   iNautix,

---

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

6 Answers   Cap Gemini, CTS,

---

Can any one explain or sujjest some sites for scd mappings.Thank you

1 Answers   Wipro,

---