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
- 9933 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / swarna.latha165
please tell me the solution
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
How can repository reports be accessed without sql or other transformations?
Explain the mapping variable usage example in informatica
lookup transformation with screenshots
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Enlist some properties of sessions.
What the difference is between a database, a data warehouse and a data mart?
What are the limitations of joiner transformation?
design of staging area?
Tell me about Propagate functions in informatica
Explain the scenario which compels informatica server to reject files?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is data transformation manager process?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
what is the size of your data warehousing?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
