Interested to Buy Any Domain ? << Click Here >> for more details...
How will you display "Mr" for male & "Mrs" for female in
target table?
- 7 Answers
- 12838 Views
- I also Faced
- E-Mail Answers
Answer Posted / giri
Use Expression Transformation
Add new Field
Condition
IIf(fieldname='male','Mr','Mis')
This field Check Variable then
add newfield Concat(newfield,first name)
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Explain in detail scd type 2 through mapping.
waht type of interface is used for testing the data in informatica
tell me the rules and responsblites in our project(my project is development)
How can we handle two sessions in informatica?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is the use of code page?
What are the types of caches in lookup? Explain them.
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are data-driven sessions?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Suppose we do not group by on any ports of the aggregator what will be the output?
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?
What are the components of the workflow manager?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is the maplet?
