Answer / ravindra.15aug

In RDBMS we can write sql queary in Source qualifer by
using rowid, in sorter by using select distinct option, In
aggregator by using groupby, in Rank by using groupby.

In FF level also we can do except sql queary in source
qualifier.

Answer / akash

In addition to the above answers I will add one more option.

We can use expression to check whether a record is
repeating or not and set an output port as flag. For first
occurence of any record this flag is 1. Use router after
this with condition "i_FLAG = 1". This output will give
only unique records. Default output will give only
duplicate records.

Also we can use a filter after the above expression with
the condition "i_FLAG = 1"

Answer / priyank

For FF, place an Aggregator transformation, do a group by
on all the columns, it will remove the duplicates from the
flat file.

In Oracle, use distinct in SQ sql override to remove the
duplicates.

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  

---

Can we run session without using workflows?

5 Answers   TCS,

---

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,

---

What do you mean incremental aggregation?

0 Answers  

---

If informatica has its scheduler why using third party scheduler?

0 Answers  

---

what is mean by complex business rule ?

0 Answers   Cap Gemini,

---

how to obtain performance data for individual transformations.

2 Answers  

---

What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?

5 Answers   TCS,

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

0 Answers  

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

0 Answers   Amazon,

---

how to join the 2 different table with different columns in informatica?

5 Answers   Accenture,

---

Why touse stored procedure in ETL Application?

2 Answers  

---