Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
No Answer is Posted For this Question
Be the First to Post Answer
Tell me one complex query in oracle ?
what is mapping optimization? wat are the techniques for tat
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
differences between service based and product based?
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach
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.
Could any one to tell Fact table Partitioning?
what is diff b/t sorter t/r and agg have the option sorter property...
How many number of sessions that u can create in a batch?
What is meant by lookup transformation?
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .