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
Answer Posted / 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 |
Post New Answer View All Answers
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the types of schemas we have in data warehouse and what are the difference between them?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is difference between a gateway node and worker node?
Write the advantages of partitioning a session?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How an expression transformation differs from aggregator transformation?
Explain the different lookup methods used in informatica?
What does command task mean?
what is SDLC way of code development?
How is union transformation utilized?
Explain the informatica workflow?
Explain constraint based loading in informatica
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How does a rank transform differ from aggregator transform functions max and min?