Answer / anoymous

Create a file system with extension .txt in that copy all
the 10 flat file paths.

Now at session level
source type : indirect
File directory : File system path
source file name: Name of file system.txt

Answer / venkat

Create one parameter file and give all 10 flat files paths
in paramer file and use this parameter file in session
properties giving parameter file path and target should be
indirect than load in to target with single source.

Answer / siva

using file Repository. source type :indirect

Answer / arnab

Concat all the files using a Unix shell script to create a
new file and use this as the source file

If you use windows create a dos batch script

Then call the Unix shell script before calling the session
in the workflow , so that the process is automated

Answer / prasuna

Hi shiva,thanks for giving answer..can u elaborate the
answer??

Two different admin users created for repository are ______ and_______

1 Answers  

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  

what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  

How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers   TCS, Tech Mahindra,

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,

when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  

Quickly characterize reusable change?

0 Answers  

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

0 Answers  

What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,

What are the different types of Type2 dimension maping?

1 Answers  

What are the options in the target session of update strategy transsformatioin?

2 Answers