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
- 9888 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / davan
In expresion t/r just give data type as string only...
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is workflow? What are the components of workflow manager?
Define update strategy?
Explain lookup transformation source types in informatica
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Do you find any difficulty while working with flat files as source and target?
What if the source is a flat-file?
What does cheating measurement mean?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the different options available for update strategy?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Explain transaction control transformation in informatica
what is the -ve test case in your project.
What does reusable transformation mean?
