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 |
If you want to create indexes after the load process which transformation you choose?
what is the size of u r project? and what is the size of source file?
What is confirmed fact in dataware housing?
write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
How identifying bottlenecks in various components of informatica and resolving them?
How do you update the records with or without using update strategy?
Performance wise which is better joiner or look up ? Give me with example?
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
In joiner, how to load Master table in Target?
If u select groupby port in aggregator what is output and dont select groupby option what is output
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,