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
- 11852 Views
- Accenture, I also Faced
- E-Mail Answers
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
What is a router transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Can anyone tell me the new features in Informatica 9 Version?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is update strategy transform?
r u done any partitions in ur project?
What is the difference between STOP and ABORT options in Workflow Monitor?
How you know when to use a static cache and dynamic cache in lookup transformation?
What are the different components of powercenter?
Differentiate between source qualifier and filter transformation?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What does refresh system mean, and what are its distinctive choice?
What is the difference between informatics 7x and 8x and what is latest version?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
