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
- 1 Answers
- 2208 Views
- CTS, I also Faced
- E-Mail Answers
Answer / Devendra Dangwal
To load the specified percentage of records while excluding bad ones, you can use SQL filters and Informatica transformation logic. Here's a general approach: 1. Identify bad records using a filter condition (e.g., NULL values or specific error codes). 2. Create separate output paths for good and bad records using the "Split" transform in Informatica. 3. Use the "Filter" transform on each output path to include only the required percentage of records. For example, for business records: Filter - Business Records (70%) > Condition: Business_Column IS NOT NULL. Repeat this step for sales and details records with the respective percentages. 4. Merge the filtered outputs using the "Union" transform. 5. Load the merged output to your target.
| Is This Answer Correct ? | 0 Yes | 0 No |
what are the difference between Informatica 7.1 and 8.1?
What is the maplet?
Enterprise data warehouse your projects phase by phase explain?
hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
daily how much amount of data send to production?
What is the benefit of partitioning a session?
What is the difference between normal and bulk loading? Which one is recommended?
Can u generate reports in Informatica?
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
what are the settiings that u use to cofigure the joiner transformation?
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
Teradata 
