What is sorter transformation?
No Answer is Posted For this Question
Be the First to Post Answer
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
Which development components of informatica have the highest usage?
What is facttable granularity?
3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?
how to join the two flatfiles using the joiner t/r if there is no matching port?
Explain about HLD and LLD ?
can we use self join in informaitca?
Can we use the mapping parameters or variables created in one mapping into another mapping?
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
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
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks