How will you display "Mr" for male & "Mrs" for female in
target table?
Answer Posted / madhusudhana reddy
decode(gender,male,'Mr',Female,'Mrs,optional)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the advantages of using informatica as an etl tool over teradata?
What is a dimensional model?
What is a shortcut and copy in Informatica and how two are different with each other?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How many number of sessions can one group in batches?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Separate from a database, an information bazaar, and an information stockroom?
Please let me know how to make Data masking in informatica..
How to generate sequence numbers using expression transformation?
What the difference is between a database, a data warehouse and a data mart?
What differs when we choose the sorted input for aggregator transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?