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
- 11800 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
Can you generate sequence numbers without using the sequence generator transformation?
what is the size of u r source(like file or table)?
What is the function of aggregator transformation?
What all are steps in up gradation of Informatica server?
Slowly changing dimensions, types and where will you use them
Differences between version 7.x and 8.x.
How will the document be delivered to me?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is an unconnected transformation?
On which transformations you created partitions in your project?
What is informatica etl tool?
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.
Explain what transformation and how many are there in informatica?
What is aggregate cache in aggregator transformation?
explan ur project architecture?
