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 / swarna.latha165
please tell me the solution
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
How to use pmcmd utility command?
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
Differences between connected and unconnected lookup?
Define update strategy?
How to generate sequence numbers using expression transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How do you handle two sessions in Informatica
What is update strategy transform?
What is rank index in rank transformation?
What are junk dimensions?
Which transformation is needed while using the Cobol sources as source definitions?
tell me the rules and responsblites in our project(my project is development)
How does a rank transform differ from aggregator transform functions max and min?
What all are steps in up gradation of Informatica server?
What is lookup change?