a soure table has 100 records how to load into 3 target
tables in a cumulative order
source target1 target2 target3
--------- -------------------------------------
1-100 1 2 3
4 5 6
- - -
98 99 100
Answer Posted / babu
Hi
Mapping:
========
Src==>SQ==>Exp==>Rtr(GRP1,GRP2,GRP3)==>T1,T2,T3
||
Seq
EXp:column1,Nexval(come from Seq Trans)
Rtr: have 3 groups
GRP1:MOD(Nextval,3)=1 ===>T1
GRP2:MOD(Nextval,3)=2 ===>T2
GRP3:MOD(Nextval,3)=0 ===>T3
| Is This Answer Correct ? | 23 Yes | 0 No |
Post New Answer View All Answers
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
update strategy transformation in informatica
generate date / time dimension in informatica
Differentiate between a repository server and a powerhouse?
what is the hint? how to use it to reduce the query processing in program?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
r u done any partitions in ur project?
Explain direct and indirect flat file loading (source file type) - informatica
Suppose we do not group by on any ports of the aggregator what will be the output?
Write the unconnected lookup syntax?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Can we get 1st record through Informatica(without sequence number).
Explain joiner transformation in informatica