Design a mapping to get year of join for each employee.
Answer Posted / abdul
can we use GET_DATE_PART Function?
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Explain incremental aggregation in informatica
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Write the advantages of partitioning a session?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is the sequence generator transformation in informatica?
How to call shell scripts from informatica?
What are the types of caches in lookup? Explain them.
What is the scenario which compels informatica server to reject files?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How to update source definition?
Can you use flat files in Mapplets.
How would you join a node to the already existing domain?
How can you validate all mappings in the repository simultaneously?
How to generate sequence numbers without using the sequence generator transformation?