Interested to Buy Any Domain ? << Click Here >> for more details...
if we have certain records,if i need to get 5 th rec for the
first time to the target,when i run it for next time,i need
to get 6th rec...like that it should process.what wil be the
procedure to achieve it??
- 1 Answers
- 6291 Views
- IBM, I also Faced
- E-Mail Answers
I guess this should work ........
Source --> SQ --> Exp --> Filter --> Exp --> Target
|
|
SG
Firstly create a mapping variable say $$count and give it
the default value 5.
Create a port in Expression say Srno. and connect the
sequence generator to it (so that it will mark the rownums).
Then in Filter place the condition Srno = $$count
In the second Expression create an extra port and give it
the value SETCOUNTVARIABLE($$count) (this will increment
the mapping variable).
Next time the job runs it will take value of $$count as 6
and so on ........
Kindly revert if this worked ........
| Is This Answer Correct ? | 20 Yes | 1 No |
How can a transformation be made reusable?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
What are active and passive transformations?
What do think which one is the better joiner or look up?
how can import the data from the flat files?
How to load the data from a flat file into the target where the source flat file name changes daily?
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
How the Informatica Server reads perameter file?
I need an oracle query for convert Char to Integer?. Can any one help me how to do this?
Can you copy the batches?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Teradata 
