If one flat file contains n number of records., we have to
load the records in target from 51 to 100.. how to use
expressions in Informatica..?
Answer Posted / gurava reddy
Source-SQ-SEQ-FILTER-TARGET
1.Connect the sequence genarater(NEXTVAL) to filter in filter
IIF(NEXTVAL>=50 and NEXTVAL>=100,TRUE, FALSE)
2. Then connect the ports to destination(Target)
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
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
What are the main features of Oracle 8i with context to datawarehouse?
What is resilience time?
Difference between Data and Index Caches?
What will be the approach?
Which version configuration tool used in ur project?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How can we improve session performance in aggregator transformation?
Explain transaction control transformation in informatica
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is depict expression change?
Explain what are the different types of transformation available in informatica.
What is parallel processing in informatica?
What is sequence generator transformation in informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?