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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Name the different lookup cache(s)?

703


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1004


Enterprise data warehouse your projects phase by phase explain?

1458


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1619


What is union transformation in informatica?

695






What are the differences between joiner transformation and source qualifier transformation?

620


Describe data concatenation?

568


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

780


How to generate sequence numbers?

616


State the limitations where we cannot use joiner in the mapping pipeline?

543


Explain joiner transformation in informatica

664


Describe the impact of several join conditions and join order in a joiner transformation?

643


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1682


Enlist some properties of sessions.

623


Explain the mapping variable usage example in informatica

629