How can we remove the duplicates from flat file source?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

what is $$$$?

0 Answers   TCS,


write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

2 Answers   TCS,


what is lookup chache?

1 Answers   Patni,


have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,


hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.

2 Answers  






diffrence between command task and control task

1 Answers   iNautix,


who is the best faculty for informatica in hyderabad ameerpet?

1 Answers  


i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  


what is dynamic cashe

3 Answers   Informatica,


Explain sessions. Explain how batches are used to combine executions?

0 Answers  


how can u load the data in time dimension?

3 Answers  


If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,


Categories