what is mystery dimension?
Answer / pradeepreddygade
using Mystery Dimension you are maintaining the junk data in
your Project. Mystery Dimension are also known as Junk
Dimensions
Is This Answer Correct ? | 5 Yes | 0 No |
Why update strategy and union transformations are active? Explain with examples.
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
what is hash table in informatica?
I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?
how to get the first row without using rank t/r?
How to extract sap data using informatica? What is abap? What are idocs?
comonly how meny mappings r there in Banking projects?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How many transformations can be used in mapplets.
In a sequential batch can you run the session if previous session fails?
What is a filter transformation and why it is an active one?
Explain lookup transformation is active in informatica