Answer / bsgsr

conncet the flat file to sorter transformation and select
distinct option.

Answer / sushanth1234

Connect the flat file to sorter tx and make ascending and connect from sorter to aggregator
tx make group by port and one o/p port count(port) after use router tx 2 group 1)count<0 and 2)count=0 transfer to target for both group Unique and dublicate.

What are the main issues while working with flat files as source and as targets ?

0 Answers   Informatica,

---

Can you copy the session to a different folder or repository?

1 Answers  

---

what is fact and what types of fact tables is there

4 Answers   Cap Gemini,

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

---

What is depict expression change?

0 Answers  

---

If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,

---

What are the modules in Power Center

0 Answers  

---

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---

performance wise which one is better in joiner and lookup transformation

2 Answers  

---

wht is full process of Information source to target just like stg to productuon and development

1 Answers   Informatica,

---

What is souce qualifier transformation it is active or passive

2 Answers   HCL,

---

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?

3 Answers   Polaris,

---