-
What is Router transformation?
Router transformation allows you to use a condition to test data. It is similar to filter transformation. It allows the testing to be done on one or more conditions.
-
What is the maplet?
Maplet is a set of transformations that you build in the maplet designer and U can use in multiple mapings.
-
What r the types of lookup caches?
Persistent cache: U can save the lookup cache files and reuse them the next time the informatica server processes a lookup transformation configured to use the cache. Recache from database: If the persistent cache is not synchronized with he lookup table,U can configure the lookup transformation to rebuild the lookup cache. Static cache: U can configure a static or readonly cache for only lookup table.By...
-
Which one is better between connected and unconnected lookup?
In lookup which one is better one connected and unconnected lookup?performance wise i am asking?if i am using five connected lookup in mapping that time what happens?
-
-
-
How to only last 100 records from a flatfile?
Thru informatica how we can load only last 100 records.
-
Mapplet Transformations
What are the transformations not used in mapplet and why?
-
Unconnected Lookup
In which situation do we use unconnected lookup?
-
-
-
-
Scenario based
If I have a source as below:Employeed, FamilyId, Contribution1,A,100002,A,200003,A,100004,B,205,B,20________________________________And my desired target is as below:EmployeeId,Contribution(In Percent)1,25%2,50%3,25%4,50%5,50% ____________________________________________________________________________Explanation: The contribution field in target is the individual Employee's share in a family's contribution.Say...
-
-
Transformation to Load 5 Flat files
What is the method of loading 5 flat files of having same structure to a single target and which transformations will you use?
-
Joiner Transformation Master Detail
Suppose you have 2000 records in one table and 12000 in another which one you will consider as master and detail?
-
Load only the First and Last Record
How to load only the first and last record of a flat file into the target?
-
In which condtions we can not use joiner transformation(Limitaions of joiner transformation)?
Both pipelines begin with the same original data source. Both input pipelines originate from the same Source Qualifier transformation. Both input pipelines originate from the same Normalizer transformation. Both input pipelines originate from the same Joiner transformation. Either input pipelines contains an Update Strategy transformation. Either input pipelines contains a connected or unconnected...
-
-
Informatica Interview Questions
Ans