How will you display "Mr" for male & "Mrs" for female in
target table?
- 7 Answers
- 10596 Views
- I also Faced
- E-Mail Answers
Answer Posted / rkumar.etl
based on flag for male and female we can use decode logic at
expression level before loading records to the target tables.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Enlist the tasks for which source qualifier transformation is used.
What is the sql query overwrite in source qualifier in informatica
Differentiate between joiner and lookup transformation?
What do mean by local and global repository?
What do you understand by SOA of Informatica?
What is meant by lookup transformation? Explain the types of lookup transformation?
How we can create indexes after completing the load process?
Explain the etl program with few examples.
What is different between the data warehouse and data mart?
What is sq transformation?
What does reusable transformation mean?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Under what condition selecting sorted input in aggregator may fail the session?
How to update or delete the rows in a target, which do not have key fields?
can you please explain me pre session and post session options?
