1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO
CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF
RUNNING ?

Question Posted / ranjan

Answers were Sorted based on User's Feedback



ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHE..

Answer / divi

I think we can change it in session properties of mapping
tab.if select flatfile on top of that we see set file
properties.

Is This Answer Correct ?    15 Yes 0 No

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHE..

Answer / bsgsr

hi, divi,
ur access to the subject is cool.
i go with your answer.
thanks.

Is This Answer Correct ?    0 Yes 3 No

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHE..

Answer / abhinav

@Divi: I did not understand your answer. Can somebody
please explain what exactly did Divi suggest doing?

I can only think of using a pre-session shell script to
replace all commas with any other delimiter.

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Informatica Interview Questions

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers   IBM, TCS,

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

0 Answers   Puma,

What is a rank transform?

0 Answers  

I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,




What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

0 Answers  

how to create user defined function (udf) in informatica

0 Answers   Informatica,

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

1 Answers   Puma,

how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

7 Answers   TCS,

Why the workflow is failed after running two hours in informatica?

1 Answers   GE,

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 Answers  

For more Informatica Interview Questions Click Here
Categories