Interested to Buy Any Domain ? << Click Here >> for more details...
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
- 6 Answers
- 11843 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / kamlesh mishra
Use is_number(field) and not is_number(field) functions in router transformations
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is pmcmd command?
What is the scenario which compels informatica server to reject files?
Explain sessions?
list out all the transformations which use cache?
Explain Dataware house architecture .how data flow from intial to end?
can u any challenge your project?
How to generate or load values in to the target table based on a column value using informatica etl tool.
COM components can be used in Informatica
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How union transformation is used?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Explain what transformation and how many are there in informatica?
What is substr in informatica?
How to partition the Session?
