How will you display "Mr" for male & "Mrs" for female in
target table?
Answer Posted / addy
This can be done by the Expression Transformation easily.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Explain in detail scd type 2 through mapping.
What is meant by lookup transformation?
What the difference is between a database, a data warehouse and a data mart?
How do you migrate data from one environment to another?
how to load rows into fact table in data warehouse
What is the reusable transformation?
What is the difference between router and filter?
What are the differences between a connected lookup and unconnected lookup?
What is an expression transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Define enterprise data warehousing?
How to generate sequence numbers without using the sequence generator transformation?
Design time, run time. If you don't create parameter what will happen