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
- 10373 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 SDLC way of code development?
What do you mean by blocking transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to use pmcmd utility command?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Explain the different kinds of facts.
Can you use flat files in Mapplets.
Where is metadata stored?
Which are the different editions of informatica powercenter that are available?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is a surrogate key?
What is an Integration service in Informatica?
expain about the tune parameters?
Design time, run time. If you don't create parameter what will happen
what is the Default Source Option For Update Strategy Transformation?
