Hi Praveen,
First we have to identify the bottlenecks and then optimize.
1. Target : Load the data to a table and a flat file. If there is a time difference we can say that there is a target...
Type: Posts; User: ggk.krishna; Keyword(s):
Hi Praveen,
First we have to identify the bottlenecks and then optimize.
1. Target : Load the data to a table and a flat file. If there is a time difference we can say that there is a target...
Hi Jagadishwar,
Thanks for your reply.
I used some other condition i.e mod(num,2)=0 for even number in router transformation. Its working.
num is the column created to hold the serial number,...
Hi friend,
In one case we can design a mapping without a SQ transformation, i.e if the source is a COBOL file, we have to use "Normaliser" transformation in place of SQ transformation.
If...
Hi friends, my question is
I have 100 records in a source flat file. I want to load odd number records into one target table & even number records into another target table.
Using Informatica how...