Skip navigation
Contact Us
3443 Views 3 Replies Latest reply: Nov 15, 2012 8:27 AM by Amit Kumar Sinha RSS
varun kumar Novice 53 posts since
Aug 28, 2012
Currently Being Moderated

Nov 12, 2012 9:41 AM

sql override in source qualifier in mapping designer

i am trying to write  sql over ride  , if suppose  i have  a,b,c,d,e  columns in source table  i need to select  a, cast(substr(d,1,10) AS DATE FORMAT 'MM-YYY-DD'), 'hello' from source table

 

my question is about  text 'hello' , after writing sql over ride  how to extract that text field from Source Qualifier  since that is not there , shall i just cretae one port in source qualifier ( not in source analyzer) and then pull and mapp into target?  does it works  or if i just pull 3rd field (c) from source then does it take 'hello'  and mapp into into target field?

 

similarly  for d field i am doing substring and then cast in sql override  but i am trying to bring d port position  to 2 nd position in source qualifier( not in source analyzer) and then taking d column from 2 nd position and mapping to target.  does this works

 

please let me know , thanks

More Like This

  • Retrieving data ...

Bookmarked By (0)