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 / vijaya
By using function isnumber(), is string() in expression editot you get the solution
Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What are the performance considerations when working with aggregator transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
which one is better performance wise joiner or look up
What is update strategy transform?
Enlist the differences between database and data warehouse.
What are the settings that you use to configure the joiner transformation?
How do you load only null records into target? Explain through mapping flow.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Do you find any difficulty while working with flat files as source and target?
How to extract the informatica rejected data?
What are mapplets?
How do you load alternate records into different tables through mapping flow?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explain what are the different versions of informatica?