Interested to Buy Any Domain ? << Click Here >> for more details...
100 records in source and i have 3 targets, my requirement
is first record insert into 1st target,2 record into 2nd
target,3 record into 3rd target and again 4th record into
1st target like dat..how to implement dis?
- 3 Answers
- 11663 Views
- Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manthiramoorthy. g
SQ-->EXP-SEQ-RTR-TARGETS
Router
=======
Make 3 Groups
MOD(NEXTVAL,3) = 0
MOD(NEXTVAL,3) = 1
MOD(NEXTVAL,3) = 2
| Is This Answer Correct ? | 13 Yes | 2 No |
Answer / mayur
SQ==>Sequence Generator(make it cycle of three)==> Filter
Tr==> Target
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / chandra
SQ--->EXP-->ROUTER---->TARs
In EXP take 2 output ports ,In one output port write
mod(id,3)=1and second Oport write mod(id,3)=2..,
Next drag the ports to ROUTER
In router take 2 groups ,IN first group write condition
mod(id,1)=1
and second group write condition mod(id,3)=2
finaly drag 3output groups into 3targets
| Is This Answer Correct ? | 3 Yes | 3 No |
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
What do you understand by term role-playing dimension?
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are the new features of informatica 9.x in developer level?
what is unique constraint error ?
what is normalization? explain 1st NF, 2nd NF, 3rd NF
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
how to load duplicate row in a target
How would you join a node to the already existing domain?
Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you
Teradata 
