How will you display "Mr" for male & "Mrs" for female in
target table?
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
where to store informatica rejected data?
Briefly explain the aggregator transformation?
Global and Local shortcuts. Advantages.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is the Process to creating lookup transformation in informatica
What is session task and command task?
Difference between Data and Index Caches?
what is unit testing?tell me proceedure
What is a transaction control transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Which version configuration tool used in ur project?
What are the main features of Oracle 8i with context to datawarehouse?
Can you generate sequence numbers without using the sequence generator transformation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
pmscmd startworkflow -sv