Interested to Buy Any Domain ? << Click Here >> for more details...
i have 1000 records in my dource table, the same i have in
target ,but a new column added in target as "batchno", and
this column adds no 10 for 1st 100 records and 20 for next
100 records and 30 next 100 records and vice versa. how to
acheive this?
- 6 Answers
- 11811 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / rocky!!
Here is another answer.
--> SEQ1
SD --> SQ --> EXP --> EXP --> TGT
--> SEQ2
1) Add SEQ1. Keep Starting value as 1 with cycle attribute set in after end value 100.
2) Add Another SEQ2. This is to keep a tab on the record count on the incoming data flow.
3) Get NEXTVAL & NEXTVAL1 from SEQ1 and SEQ2 and dump it in EXP.
4) in EXP, add Varibale port "V_OUTPUT_DECISION" and write code "CEIL(NEXTVAL1/100)"
5) in EXP, add variable "V_BATCH_NO" and initialise value as 10.
6) in EXP, add output port "OUTPUT_DECISION_BATCH_NO" and write code as "V_OUTPUT_DECISION*V_BATCH_NO"
7) connect fields viz, YEAR, DESC, MONTH, SALARY and BATCHNO to Target.
I guess this is the generic code. Bring any number records, should work.
Cheers!!
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Under which circumstances, informatica server creates reject files?
How can we use batches?
What is dimensional table?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
COM components can be used in Informatica
Explain the code page compatibility?
What do you understand by SOA of Informatica?
Is it possible to use a client with different version than that of its Informatica server?
Which files are created during the session rums by informatics server?
While migrating the data from one environment to another environment how would you manage the connections?
How you know when to use a static cache and dynamic cache in lookup transformation?
What does cheating measurement mean?
What is meant by incremental aggregation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
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
