Interested to Buy Any Domain ? << Click Here >> for more details...
Design a mapping to get year of join for each employee.
- 4 Answers
- 9325 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / abhinaw prakash
We can use Date Conversion function to find out the Year and
use SUBSTR function to extract that particular year.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is lookup change?
how we can load rejected record's at run time?(not through bad files)
What is rank transformation in informatica
How can we improve session performance in aggregator transformation?
What is the way to execute pl/sql script using informatica mapping?
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 to create user defined function (udf) in informatica
What is a standalone command task?
Explain the features of connected and unconnected lookup.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What does update strategy mean, and what are the different option of it?
What are the uses of etl tools?
How do you handle two sessions in Informatica
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
wat are deployement groups in informatica, how it will be used for developers
