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 |
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,
Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
what is lookupoverriding?
Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
tell me the rules and responsblites in our project(my project is development)
What is expression transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?