What are the measure objects?
- 1 Answers
- 1302 Views
- I also Faced
- E-Mail Answers
Answer / Gyanendra Kumar
In Informatica, Measure Objects are used in reporting and analysis. They allow you to calculate aggregate functions like sum, count, min, max, average, etc. on a group of records. Measure Objects can be used in reports, cubes, or data models.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?
what are presession,postsession success and postsession failure commands ?
explain about session partitions ?
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
If we are using an aggregator but forget to mention the group by port .what will be the output??
what is the purpose of surrogate key and diff between primary key&surrogate key
What is a connected transformation?
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
sample mappings for scd1,scd2 and scd3
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
What is the Hierarchy of DWH?
Teradata 
