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
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 |
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 |
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
What is the Difference between SetVariable and setmaxvariable in informatica?
where is the reject loader .
what are cost based and rule based approaches and what is the difference?
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..
if i have a delimited file as source so how can we seperate this file into three diff targets?
update strategy transformation in informatica
Kimball and Inmon methodologies?
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?
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?
Examples of Fatal & Non-Fatal error?