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
What are the types of schemas we have in data warehouse and what are the difference between them?
What is transformation?
What are the components of Informatica? And what is the purpose of each?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Why is sorter an active transformation?
Differences between version 7.x and 8.x.
Explain in detail scd type 2 through mapping.
Differentiate between Load Manager and DTM?
What is update strategy transform?
What is the need for an etl tool?
Write the different tools in the workflow manager?
As union transformation gives UNION ALL output, how you will get the UNION output?
Explain the features of connected and unconnected lookup.