how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
Answers were Sorted based on User's Feedback
Answer / dilip ingole
BY USING SQL
WITH DATA AS(SELECT NUM,ROWNUM RN ,COUNT(1)OVER() CNT FROM A)
SELECT NUM,RN FROM DATA WHERE RN=1
UNION
SELECT NUM,RN FROM DATA WHERE RN=CNT;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / triveni
source->sq->sequencegenerato->expression->filter->target
nextval to expressiontransformation
seq(output) decimal 10 nextval
startval=1,endvalue=14,cycle
mapping variable:$$var varible integer 10 o max
intialvalue=0
filter decimal 10
setvariable( $$seq,($$seq+1))
Is This Answer Correct ? | 1 Yes | 3 No |
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Are there any types of Dynamic Caches in informatica
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
why do u use shortcuts in informatica.?
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
Different qualification between a related rotate toward the sky and isolates look upward?
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
What is a transaction control transformation?