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.

a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

2 Answers   TCS,

---

How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,

---

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,

---

How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,

---

Explain constraint based loading in informatica

0 Answers   Informatica,

---

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  

---

what is runtime variable?

3 Answers   TCS,

---

What are mapplets?

0 Answers  

---

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,

---

Describe an informatica powercenter?

0 Answers  

---

How will u pas the data with out debugger?

4 Answers  

---

There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

2 Answers   L&T,

---