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
Name the different lookup cache(s)?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Enterprise data warehouse your projects phase by phase explain?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is union transformation in informatica?
What are the differences between joiner transformation and source qualifier transformation?
Describe data concatenation?
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.
How to generate sequence numbers?
State the limitations where we cannot use joiner in the mapping pipeline?
Explain joiner transformation in informatica
Describe the impact of several join conditions and join order in a joiner transformation?
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
Enlist some properties of sessions.
Explain the mapping variable usage example in informatica