Design a mapping to get year of join for each employee.
Answer Posted / ganesh reddy
use expression t/r in exp write to_char(hiredate,'yyyy')
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you convert single row from source into three rows into target?
Explain lookup transformation is active in informatica
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
update strategy transformation in informatica
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is meant by pre and post session shell command?
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
As union transformation gives UNION ALL output, how you will get the UNION output?
what is size of u r database?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is parallel processing 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?
How do we call shell scripts from informatica?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Can u generate reports in Informatica?