following scenario i have 1000 record flatfile source i
want ist row to ist target 2nd eow to 2nd target 3rd row to
3rd target how will u do?
- 7 Answers
- 8454 Views
- Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / suresh
Use Sequence generator
In sequence generator set the properties
start value 1
end value 3
cycle yes
conn sequence generator to exp and test in router
| Is This Answer Correct ? | 10 Yes | 1 No |
Hi suresh you are 50% current
sq-->expression-----> rooter----->t1
seqno/ ------t2
-------t3
drag the all columns to expression create one new column this column connect sequence generator connect NEXT VALUE
In sequence generator set the properties
start value 1
end value 3
cycle yes
later exp-->router connect hear create 3 groups
group1-NEXT VALUE=1
group2-NEXT VALUE=2
group3-NEXT VALUE=3
first group connect to T1
second group connect to t2
third group connect to t3
is 100% correct
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / venkat
->Connect desired columns to Expression and create custom
colum.
->Use Sequence Gen inorder to generate cyclic values 1,2,3
logic :start with 1 ,increment by 1 and end with 3
Cycle -Yes.
->Connect it to Custom column
->Use Router to rout coresponding group
Group1 -Value1- Target1
Group2 -Value2- Target2
Default-Value3- Target3
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / triveni
startvalue=1
endvalue=3
cycle=yes seequencegenerator
\
source->sq->expression->router->target1
->target2
expression->copy nextval port to expression
router->mod(seq,3)=1
mod(seq,3)=2
mod(seq,3)=0
| Is This Answer Correct ? | 0 Yes | 0 No |
Which development components of informatica have the highest usage?
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
how much memory (size) occupied by a session at runtime
What is mapplet and a reusable transformation?
What is Java Transformation? what are the uses of it?
How can the following be achieved in 1 single Informatica Mapping. * If the Header table record has error value(NULL) then those records and the corresponding child records in the SUBHEAD and DETAIL tables should also not be loaded into the target(TARGET1,TARGET 2 or TARGET3). * If the HEADER table record is valid, but the SUBHEAD or DETAIL table record has an error value (NULL) then the no data should be loaded into the target TARGET1,TARGET 2 or TARGET3. * If the HEADER table record is valid and the SUBHEAD or DETAIL table record also has valid records only then the data should be loaded into the target TARGET1,TARGET 2 and TARGET3. =================================================== HEADER COL1 COL2 COL3 COL5 COL6 1 ABC NULL NULL CITY1 2 XYZ 456 TUBE CITY2 3 GTD 564 PIN CITY3 SUBHEAD COL1 COL2 COL3 COL5 COL6 1 1001 VAL3 748 543 1 1002 VAL4 33 22 1 1003 VAL6 23 11 2 2001 AAP1 334 443 2 2002 AAP2 44 22 3 3001 RAD2 NULL 33 3 3002 RAD3 NULL 234 3 3003 RAD4 83 31 DETAIL COL1 COL2 COL3 COL5 COL6 1 D001 TXX2 748 543 1 D002 TXX3 33 22 1 D003 TXX4 23 11 2 D001 PXX2 56 224 2 D002 PXX3 666 332 ======================================================== TARGET1 2 XYZ 456 TUBE CITY2 TARGET2 2 2001 AAP1 334 443 2 2002 AAP2 44 22 TARGET3 2 D001 PXX2 56 224 2 D002 PXX3 666 332
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
if i am having 10 records in source, i want 20 records in target...how will you do it
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
Teradata 
