what is mean by grouping of condition column in lookup
transformation?
Answer / rashmi garg
grouping of condition colum means- the columns which we
have included in lookup conditions, the lookup source
should data should be grouped on that column.
this is mandatory for flatfiles, otherwise the session will
fail
Is This Answer Correct ? | 2 Yes | 1 No |
Performance wise which is better joiner or look up ? Give me with example?
replace multiple spaces with single space.
How do you set a varible in incremental aggregation
In any project how many mappings they will use(minimum)?
Does an informatica transformation support only aggregate expressions?
Why should we use star schema in datawarehouse design?
what is degenerated dimension
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Mention few advantages of router transformation over filter transformation.
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How do you remove duplicate records in informatica? And how many ways are there to do it?