Answer / gsr

When you are using Flat File source you usually get the
header files separately from the data files. You may get
source data in more than one file. In such cases you give
the paths of all the data files in one file for eg say
list.txt. This file is called the list file. In the session
edit task window instead of giving the source filename you
enter the name of the list file - list.txt and in source
filetype you make it indirect.

Answer / shweta

When we use Flat file as a source we give the path of
directory where we store the file in Workflow.
But if we want data from multiple flat files then we put
the names of all flat files in a single file called as file
list.
In workflow mapping we give the path of list file and mark
the source filetype as INdirect as we are indirectly
accessing all the flat files.

Answer / arockia

In File list is it possible to create seperate target files
for each input file?? Ex: My list.yxy contains :
datafile1.dat,datafile2.dat. I want target file needs to be
created as datafile1.out, datafile2.out..

Please help...

Answer / shashiall

may b it is the path where our flat file is residing.we
have to give the total path at the place of the file
list...
plz...correct me if am wrong...

How can you increase the performance in joiner transformation?

0 Answers  

---

select count(1) from emp? what is the o/p?

5 Answers   TCS,

---

scenario

1 Answers  

---

without matching columns in two tables. how can you join

5 Answers   BirlaSoft,

---

what is SDLC way of code development?

0 Answers  

---

In session log thier should not be a single error how will u do

3 Answers   HCL,

---

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  

---

What are mapplets? How is it different from a Reusable Transformation?

0 Answers   Informatica,

---

what is hash table in informatica?

1 Answers   Zensar,

---

how many data models u have done in informatica project?

2 Answers   TCS,

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

0 Answers   IBM,

---

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,

---