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

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

Question Posted / indraraj yadav


What if the source is a flat-file? Then how can we remove the duplicates from flat file source?..

Answer / 9019

Sorter select distinct, aggregator group by columns

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is the difference between STOP and ABORT options in Workflow Monitor?

0 Answers  

what is diff between grep and find

3 Answers   IBM, iFlex,

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

0 Answers  

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers   Accenture,

What is the difference between view and materialised view?

6 Answers  




Why do we use DSS database for OLAP tools?

2 Answers  

How can you run a session without using server manager?

1 Answers  

Explain load alternative records / rows into multiple targets - informatica

0 Answers   Informatica,

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,

What happens if we dont select data driven option?

2 Answers   Zensar,

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

How to load data in informatica ?

0 Answers  

For more Informatica Interview Questions Click Here
Categories