How can you define a transformation? What are different
types of transformations in Informatica?
Answer Posted / k.pavan
transforamtion is a business logics, it transfers the data is call transformatio, transformations are different types these are in the given below.
1.filter .
2.expression.
3.router.
4.lookup.
5.joiner.
6.aggregator.
7.update strategy.
8.rank.
9.normalizer.
10.sequence generator.
11.source qualifier.
12.reusable.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is a joiner transformation and why it is an active one?
What is source qualifier transformation in informatica?
Explain direct and indirect flat file loading (source file type) - informatica
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is informatica metadata and where is it stored?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What do you understand by SOA of Informatica?
whats the logic to load the lower level of granularity of data to fact table.
What is an Integration service in Informatica?
What will be the approach?
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?
How do you handle two sessions in Informatica