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?
Answer Posted / santosh kumar sarangi
1.in expression t/r create one more port as below.
FLAG(integer)=IIF(LOWER(COL1)=UPPER(COL1) ,1,0)
2.Link the original port and FLAG port to router and create
a group as FLAG=1
3.Link the original port from the group to target of number
or special charater and default to target of character.
Let me know if any things wrong
Thanks and Regards
Santosh
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Whats there in global repository
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How can we create index after completion of load process?
Informatica Checkpoints
If informatica has its scheduler why using third party scheduler?
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. ?
Difference between Data and Index Caches?
Target increases every day even though no new record was inserted
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
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.
can anyone explain me about retail domain project in informatica?
Describe the impact of several join conditions and join order in a joiner transformation?
What is the function of aggregator transformation?
Briefly explain the aggregator transformation?