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
- 9934 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
what is the -ve test case in your project.
Explain scd type 3 through mapping.
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are the different options available for update strategy?
What does reusable transformation mean?
Slowly changing dimensions, types and where will you use them
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Difference between Data and Index Caches?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain about cumulative Sum or moving sum?
What do mean by local and global repository?
What do you understand by a term domain?
What is persistent lookup cache?
How to do unit testing in informatica? How to load data in informatica ?
