there is a comma separated flat file as source and there is
a column in that one field is having space like "rama
krishna" like that what happens when this is used as source
Answers were Sorted based on User's Feedback
Answer / srinivas
i have tested when we use coma seperated file it should
take only rama krishna as single column
| Is This Answer Correct ? | 23 Yes | 0 No |
Answer / kishore
Hi,
I think ...it will take separate column when comma(,) occurs
only..... "rama krishna: as single column only....
| Is This Answer Correct ? | 11 Yes | 1 No |
There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Tell me one complex query in oracle ?
What is data movement mode in Informatica and difference between them?
As union transformation gives UNION ALL output, how you will get the UNION output?
If you want to create indexes after the load process which transformation you choose?
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
where does the default group roew in a router is stored what is the default size of memory in router
what is distinct
enterprise datawarehouse your project phase by phase explain?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
i want excute multiple sessions in one workflow using the "start task".what do i need to do?