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

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

What do you mean by channel change?

0 Answers  


Mention few advantages of router transformation over filter transformation.

0 Answers  


Clarify the utilization of aggregator cache record?

0 Answers  


how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers   CTC,


What is Java Transformation? what are the uses of it?

0 Answers   TCS,






Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

0 Answers   TCS,


There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

9 Answers   TCS,


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

0 Answers  


Write the prerequisite tasks to achieve the session partition?

0 Answers  


What are the different types of transformation available in informatica.

0 Answers  


Differentiate between a repository server and a powerhouse?

0 Answers  


Explain the different lookup methods used in informatica?

0 Answers  


Categories