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

i have 2 flat files one table contains duplicates another one
no duplicates.... so i need like this i don't want
duplicates...pl's give me ans...

Question Posted / chennapanaidu

Answers were Sorted based on User's Feedback



i have 2 flat files one table contains duplicates another one no duplicates.... so i need like thi..

Answer / teja

place sorter transformation after source qualifier of duplicates flatfile and enable property distinct

Is This Answer Correct ?    5 Yes 1 No

i have 2 flat files one table contains duplicates another one no duplicates.... so i need like thi..

Answer / guest

with the help of joiner transformation we can join these two
flat file sources and reject the duplicate rows using normal
join in joiner transformation

Is This Answer Correct ?    6 Yes 4 No

i have 2 flat files one table contains duplicates another one no duplicates.... so i need like thi..

Answer / ankit kansal

Hi Gow,
As Question specified there are two source files so you can not user Distinct clause in Source Qualifier.

http://deepinopensource.blogspot.com/

Is This Answer Correct ?    0 Yes 1 No

i have 2 flat files one table contains duplicates another one no duplicates.... so i need like thi..

Answer / gow

Hi Teja

We can use distinct option in source qualifier of the table having duplicate records itself right? Why do we need to use sorter after the source qualifier?.

Please correct me if i am wrong.

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Informatica Interview Questions

How do you load alternate records into different tables through mapping flow?

0 Answers  

when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,

what is metadata?

8 Answers   Satyam,

design of staging area?

0 Answers  

What is the difference between a router and a filter transformation?

1 Answers   TCS,




Design a mapping to get year of join for each employee.

4 Answers   Accenture,

Tell me about informatica architecture.

2 Answers   TCS,

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

4 Answers   CSC,

How to generate sequence numbers using expression transformation?

0 Answers   Informatica,

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  

Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers  

For more Informatica Interview Questions Click Here
Categories