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

how to we create datamart?

2 Answers   HSBC,

---

In which scenario did you used pushdown optimization?

1 Answers  

---

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  

---

what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers  

---

In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1 Answers   HP,

---

---

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,

---

Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva

1 Answers   Accenture,

---

Explain in detail about scd type 1 through mapping.

0 Answers  

---

without using rank transformation how can we rank items by using some other transformations

2 Answers  

---

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

---

Could any one to tell Fact table Partitioning?

2 Answers  

---

Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that

5 Answers   TCS,

---