Design a mapping to get year of join for each employee.
Post New Answer View All Answers
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is meant by a domain?
How do we call shell scripts from informatica?
Enterprise data warehouse your projects phase by phase explain?
What are mapplets?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
generate date / time dimension in informatica
What are the static cache and dynamic cache in informatica?
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
How do you load only null records into target?
Explain the aggregator transformation?
Difference between Target-based loading and constraint-based loading?
Explain the types of transformations?
without table how to come first record only in oracle?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?