-
How to only last 100 records from a flatfile?
Thru informatica how we can load only last 100 records.
-
What r the join types in joiner transformation?
Normal (Default) Master outer Detail outer Full outer
-
Flat File as Source in Informatica
How can we receive source as flat file in informatica, from where we get this flat file?
-
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?
-
-
What are Dimensions and various types of Dimensions?
set of level properties that describe a specific aspect of a business, used for analyzing the factual measures of one or more cubes, which use that dimension. Egs. Geography, time, customer and product.
-
-
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