Interested to Buy Any Domain ? << Click Here >> for more details...
how to import multiple flat files in to single target where
there is no common column in the flat files
- 2 Answers
- 7326 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ramana sreepathi
in workflow session properties in Mapping tab
in properties
choose Source filetype Indirect
Give the Source filename : <file_path>
This <file_path> file should contain all the multiple files
which you want to Load
| Is This Answer Correct ? | 9 Yes | 2 No |
Please let me know how to make Data masking in informatica..
source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?
Differentiate between source qualifier and filter transformation?
What is workflow variable? When we use workflow variable? Can any one explain me with one example???
What is data merging, data cleansing and sampling?
Explain how many types of dimensions are available in informatica?
1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??
What is ThroughPut in Informatica, How it works, Where I can find this option to check ?
what is dynamic cashe
what r the transformations that r not involved in mapplet?
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
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.
Teradata 
