1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

my table contain duplicate Records i wanna load uniq records
to my table . i have to pass the uniq records through
filter t/r how?

Question Posted / gangadhar799

Answers were Sorted based on User's Feedback



my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq..

Answer / pavana

Yes, Sort the data first , then in expression increment the
count based on theprev value . in filter give condition if
count =0 . it pass only unique value.

sd >> SQ>> SRT TRN>> EXP>> FIL>> TGT.

Is This Answer Correct ?    1 Yes 0 No

my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq..

Answer / ganga

HI Dharmendra,


here i want to pass the uniq records through filter is possible are not?

Is This Answer Correct ?    0 Yes 0 No

my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq..

Answer / dharmendra singh

Use a sorter transformation after source qualifier.check
unique records in the proprrties of sorter,This will [ass
only unique record from the sorter.

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  

How do you convert single row from source into three rows into target?

0 Answers  

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,

I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?

1 Answers   Franklin Templeton,




we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,

From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,

What is IQD file?

1 Answers  

What is a snowflake schema?

0 Answers  

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.

1 Answers   DELL,

What is the difference between informatica 7.0 and 8.0?

0 Answers  

How to load a relational source into file taget?

2 Answers  

For more Informatica Interview Questions Click Here
Categories