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
- 12760 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Here the question is to just display value 'MR'for
males 'MR'for males , not to modify the data in the table
as 'MR'for males 'MR'for males
we can do it by many ways, one among those ........
select decode(column_name, 'male','MR','female','MRS')
this query displays MR for all males and MRS for all females
| Is This Answer Correct ? | 10 Yes | 2 No |
Answer / 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 |
Answer / dragon
I agree with Rkumar.etl,
but if in the database is too old and they dont have column
flag then how you u define.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / addy
This can be done by the Expression Transformation easily.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / narinder
Assuming that the source data has some kind of identifier
to track male or female record then use the decode function
based on idetifier to store 'Mr' or 'Mrs' in a port in an
expression transformation and pass this port value to
target.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / madhusudhana reddy
decode(gender,male,'Mr',Female,'Mrs,optional)
| Is This Answer Correct ? | 1 Yes | 1 No |
scenario where i can use only concurrent execution of workflow.
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
Explain the aggregator transformation?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are the Advantages of de normalized data?
what is the method of error handling when session is running?
What are the reusable transforamtions?
What is meant by target load plan?
What is the session task and command task?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
explain different types of modeling.
What is dynamic cache?
Teradata 
