Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?

3 Answers  


What is the Difference between SetVariable and setmaxvariable in informatica?

1 Answers  


where is the reject loader .

1 Answers  


what are cost based and rule based approaches and what is the difference?

1 Answers  


Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,


if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers   TCS,


update strategy transformation in informatica

0 Answers   Informatica,


Kimball and Inmon methodologies?

2 Answers  


What is the method of seperating unique and duplicate records in session level?

2 Answers   Emphasis, JBL, Wipro,


Is it possible to update the target table with PK?

1 Answers   TCS,


What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?

5 Answers   TCS,


Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,


Categories